Re: how to convert a time interval to seconds?

am  Tue, dem 12.09.2006, um 10:39:25 -0400 mailte Chansup Byun folgendes:
> Hi,
>
> I searched how to convert a time interval to seconds but failed to find
> an example.

select extract('epoch' from timestamp);

A little example:

test=*> select '5 days 5 hours'::interval;
    interval
-----------------
 5 days 05:00:00
(1 row)

test=*> select extract ('epoch' from '5 days 5 hours'::interval);
 date_part
-----------
    450000
(1 row)



http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net