am 01.12.2005, um 11:07:59 +0200 mailte Sterpu Victor folgendes:
> I need a function that will transform from the format '2002-09-08 05:29:41'
> to seconds since 1970.
scholl=# select now();
now
-------------------------------
2005-12-01 10:18:47.554236+01
(1 row)
scholl=# select extract (epoch from now());
date_part
------------------
1133428728.47011
(1 row)
scholl=# select extract (epoch from now())::int;
date_part
------------
1133428743
(1 row)
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
