Home > mailing lists

timestamp output as seconds since epoch? - Mailing list pgsql-sql

From	A.M.
Subject	timestamp output as seconds since epoch?
Date	February 26, 2003 23:17:13
Msg-id	DB35FD78-49F0-11D7-A1A6-0030657192DA@cmu.edu Whole thread Raw
Responses	Re: timestamp output as seconds since epoch?
List	pgsql-sql

Tree view

I need to grab the pgsql timestamp as an integer (seconds since epoch) 
in order to compare the dates programmatically later on. What I'd like 
is:
SELECT CAST('12/12/2004 4:50:45.3' AS TIMESTAMP)::INT8;
The docs talk alot about date input but only discuss the 4 SET 
regionalized date output methods. Thanks!><><><><><><><><><
AgentM
agentm@cmu.edu

pgsql-sql by date:

From: "Grignon Etienne"
Date: 26 February 2003, 20:47:04
Subject: pgsql problem

From: Rod Taylor
Date: 27 February 2003, 00:09:28
Subject: Re: timestamp output as seconds since epoch?

timestamp output as seconds since epoch? - Mailing list pgsql-sql

Previous

Next