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