| From: | Dawid Kuroczko <qnex42(at)gmail(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:15:34 |
| Message-ID: | 758d5e7f050426031572fbd32e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/26/05, Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> 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?
Something along lines of select extract(epoch from '1 day 2
hours'::interval) / 3600
maybe?
Regards,
Dawid
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Russell Smith | 2005-04-26 10:17:30 | Re: oid wraparound |
| Previous Message | Michael Glaesemann | 2005-04-26 10:11:09 | Re: Intervals |