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

> This is in fact wrong, unless you live in the British Isles: the
> result will be off by your timezone displacement from UTC.  Correct
> is to use timestamptz not timestamp.
> 
> As an example: timestamp 1089953023 equates to Fri Jul 16 2004, 00:43:43 EDT
> according to strftime() on my machine (I live in US Eastern zone which
> is presently GMT-4).  I get

I would actually prefer this syntax:

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2003-01-01 11:23:44');

Chris