Re: Unixtime from timedate?

From: Palle Girgensohn <girgen(at)partitur(dot)se>
To: Konstantinos Agouros <elwood(at)agouros(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unixtime from timedate?
Date: 2001-10-12 20:40:45
Message-ID: 3BC7554D.EF2576DB@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-10-12 20:44:56 Re: Joining Between Databases
Previous Message Dr. Evil 2001-10-12 20:30:02 JDBC question: Which class is returned?