Re: Calendar vs. Timestamp

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