Unixtime from timedate?
Hi,
I might be missing something in the documentation but what I would need is
the time in seconds since 1970 from a datetime-column in a table (in Perl using
DBD:Pg). Could someone help me without using Posix::mktime?
Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres
Konstantinos Agouros wrote:
Hi,
I might be missing something in the documentation but what I would need is
the time in seconds since 1970 from a datetime-column in a table (in Perl using
DBD:Pg). Could someone help me without using Posix::mktime?
select date_part('epoch',now()::date);
/Palle
--
Palle Girgensohn
Partitur Informationsteknik AB
http://www.partitur.se/partitur/visitkort/girgensohn.jpg