Re: Intervals

On 4/26/05, Jake Stride <nsuk@users.sourceforge.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