On 4/26/05, Jake Stride <nsuk@xxxxxxxxxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
