On Sep 4, 2006, at 17:58 , Alban Hertroys wrote:
Peter Eisentraut wrote:
It's not clear what the meaning of a double precision as a
timestamp would be. How about you make that explicit:
"timestamp" * interval '1 second' + timestamp '1900-01-01 00:00:00'
There's also 'EPOCH', which is shorter and more explicit.
timestamp 'EPOCH" + "timestamp" * interval '1 second'
Note that epoch does not mean 1900-01-01 00:00:00.
select timestamp 'epoch';
timestamp
---------------------
1970-01-01 00:00:00
(1 row)
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
