Postgres Pro
Downloads
Home   >   mailing lists

Unixtime from timedate? - Mailing list pgsql-general

From elwood@agouros.de (Konstantinos Agouros)
Subject Unixtime from timedate?
Date
Msg-id elwood.1002905685@news.agouros.de
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Link
Date:
Subject: Re: Performance problem with 50,000,000 rows
Next
From: Peter Eisentraut
Date:
Subject: Re: "Relation x does not exist" error when x does exist