Re: Bug in TimestampUtils.java?
| От | Richard Cook |
|---|---|
| Тема | Re: Bug in TimestampUtils.java? |
| Дата | |
| Msg-id | 20061110161940.19582.qmail@web60222.mail.yahoo.com обсуждение исходный текст |
| Ответ на | Bug in TimestampUtils.java? (Richard Cook <awhig@yahoo.com>) |
| Ответы |
Re: Bug in TimestampUtils.java?
|
| Список | pgsql-jdbc |
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)
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?
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?
-O
> 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
В списке pgsql-jdbc по дате отправления: