I didn't see any follow-up to this bug. The problem is that the
"datetime"/"timestamp" functions do not calculate the date from the
seconds since the unix epoch correctly. In bug #695, Tom Lane states that
the "timestamp" type is moving in the direction of timestamp without
timezone. It appear
Simon Kirby ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
timestamp() converts timezone in wrong direction
Long Description
timestamp() and extracting epoch from dates is totally broken: