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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to