Below is the debug output from TimestampUtils.java
It parses the date string that says -05 into an -0400 Date object.
Rich
Date String: 2006-10-29 23:00:00-05
debug output ---> Parsed date '2006-10-29 23:00:00-05' in zone America/New_York as 2006-10-29 AD 00:00:00 -0400 (millis=1162094400000)
----- Original Message ---- From: Oliver Jowett <oliver@opencloud.com> To: Richard Cook <awhig@yahoo.com> Cc: imad <immaad@gmail.com>; pgsql-jdbc@postgresql.org Sent: Friday, November 10, 2006 1:20:05 AM Subject: Re: [JDBC] Bug in TimestampUtils.java?
Richard Cook wrote:
> If you look at the source code for the postgres jdbc driver, it > retrieves the column as a string, then uses the TimeStampUtils class to > create a date or timestamp out of it. I think the driver is incorrectly > setting the timezone when it creates the Date object.
I missed the original post here, but if you retrieve the result as a String what do you get? (the exact value please) .. and how does that compare to the Date you get?