Re: Unixtime from timedate? - Mailing list pgsql-general

From Palle Girgensohn
Subject Re: Unixtime from timedate?
Date
Msg-id 3BC7554D.EF2576DB@partitur.se
Whole thread Raw
In response to Unixtime from timedate?  (elwood@agouros.de (Konstantinos Agouros))
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index Scans Oddness
Next
From: Joseph Koenig
Date:
Subject: Any Good Way To Do Sync DB's?