Postgres Pro
Downloads
Home   >   mailing lists

Re: convert sum (interval) to seconds - Mailing list pgsql-sql

From Tom Lane
Subject Re: convert sum (interval) to seconds
Date
Msg-id 5238.1031060247@sss.pgh.pa.us
Whole thread Raw
In response to Re: convert sum (interval) to seconds  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-sql
Tree view 
Oliver Elphick <olly@lfix.co.uk> writes:
> On Tue, 2002-09-03 at 11:45, Doppelganger wrote:
>> How can I convert sum(interval) to seconds?

> Here's one way;   
>     junk=# select extract (minute from sum(if)) * 60 + extract (second
>     from sum(if)) from i;

EXTRACT(EPOCH FROM interval) is designed for this ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Hubert depesz Lubaczewski
Date:
Subject: Re: RFC822 Checker
Next
From: Darren Ferguson
Date:
Subject: Re: [GENERAL] Why must the function that a trigger calls return