| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Intervals |
| Date: | 2005-04-26 10:11:09 |
| Message-ID: | 32006e067cb06c24f7e57781e91f5950@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Apr 26, 2005, at 18:47, Jake Stride wrote:
> Is there a way to convert in interval into hours? I have a table that
> records the amount of time worked by a person and want to sum up all
> the
> hours, however with the column being an interval once you reach more
> than 24 hours it turns that into a day. This is not what I want so
> instead of outputting 1day 2:00:00 I would want to output 26:00:00 is
> this possible?
Search the archives from the past couple of days of the pgsql-sql
mailing list with the subject line Re: [SQL] to_char(interval) ? and
you should find a solution. The archives can be found at
http://archives.postgresql.org
Hope this helps.
Michael Glaesemann
grzm myrealbox com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2005-04-26 10:15:34 | Re: Intervals |
| Previous Message | Clifton Zama | 2005-04-26 10:09:22 | Re: SQLException "Connection is closed. Operation is not |