Re: Calendar vs. Timestamp - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Calendar vs. Timestamp
Date
Msg-id Pine.BSO.4.63.0604111506420.17492@leary2.csoft.net
Whole thread Raw
In response to Calendar vs. Timestamp  ("Wei Wei" <wei725@lycos.com>)
List pgsql-jdbc

On Tue, 11 Apr 2006, Wei Wei wrote:

> I move this issue from the general mailing list. Here is my problem:
>
> In the Java application, I create a Calendar object and the getTime and
> getTimeZone return the following values:
>
> * Sun Apr 09 12:40:52 PDT 2006
> * Pacific Standard Time
>
> The Calendar object is matched to the timestamp with time zone data type
> throught Hibernate. And the above data is stored as the following:
>
> 2006-04-09 14:40:53.093-07
>
> That is not correct. The command of "select now()" returns a correct
> value. The PG version is 8.0.x and the jdbc version is 8.0.309.jdbc3. Is
> it a bug in the driver?
>

The 8.1 driver has better timezone/calendar support.  Please try the
latest 8.1 release and if that doesn't fix your problem, send us the java
code to reproduce your problem.

Kris Jurka


pgsql-jdbc by date:

Previous
From: "Wei Wei"
Date:
Subject: Calendar vs. Timestamp
Next
From: "Yi Lin"
Date:
Subject: FastPath blocked when ERROR is thrown