On Sun, Apr 24, 2005 at 13:08:04 -0700,
Theodore Petrosky <[EMAIL PROTECTED]> wrote:
> how do I get an interval '1 day 1 hour' to display as
> '25 hours'. I am hunting in the docs (and googling)
> and either I am blind or I need a special function?
>
> Is there an easy way?
EXTRACT epoch from the interval and divide by 3600 and concatenate to ' hours'.
area=> select extract(epoch from '1 day 1 hour'::interval)/3600 || ' hours';
?column?
----------
25 hours
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
