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