Thread: timestamp output as seconds since epoch?

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

select extract('epoch' from current_timestamp);


On Wed, 2003-02-26 at 20:14, A.M. wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc