Re: [BUGS] Bug #672: timestamp() converts timezone in wrong direction

2002-07-22 Thread Edwin Grubbs
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

[BUGS] Bug #672: timestamp() converts timezone in wrong direction

2002-05-22 Thread pgsql-bugs
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: