Re: Bug in TimestampUtils.java?

Oliver,

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(at)opencloud(dot)com>
To: Richard Cook <awhig(at)yahoo(dot)com>
Cc: imad <immaad(at)gmail(dot)com>; pgsql-jdbc(at)postgresql(dot)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?

-O