Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Converting epoch to timestamp
Date
Msg-id 16157.1089955120@sss.pgh.pa.us
Whole thread Raw
In response to Re: Converting epoch to timestamp  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Converting epoch to timestamp  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> I would actually prefer this syntax:

> 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).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Justin Clift
Date:
Subject: Re: pg_dump - option for just dumping sequences?
Next
From: Michael Glaesemann
Date:
Subject: Re: Converting epoch to timestamp