Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting epoch to timestamp - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Converting epoch to timestamp
Date
Msg-id 40F770E7.3080206@familyhealth.com.au
Whole thread Raw
In response to Re: Converting epoch to timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Converting epoch to timestamp  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-hackers
Tree view 
>>SELECT EXTRACT(EPOCH FROM TIMESTAMP '2003-01-01 11:23:44');
> 
> 
> Yeah, but I think Michael's question had to do with going the other
> way (numeric to timestamp).

Sorry,

SELECT EXTRACT(TIMESTAMP FROM EPOCH '123412341234');

Chris

pgsql-hackers by date:

Previous
From: lists
Date:
Subject: Re: XLogWrite: write request 0/53A4000 is past end of log
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: XLogWrite: write request 0/53A4000 is past end of log