Intervals - Mailing list pgsql-general

From Jake Stride
Subject Intervals
Date
Msg-id 426E0E1C.90401@users.sourceforge.net
Whole thread Raw
Responses Re: Intervals
Re: Intervals
Re: Intervals
List pgsql-general
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?

Thanks

Jake

pgsql-general by date:

Previous
From: Hubert Fröhlich
Date:
Subject: oid wraparound
Next
From: Michael Glaesemann
Date:
Subject: Re: Intervals