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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
