Calendar vs. Timestamp

From: "Wei Wei" <wei725(at)lycos(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Calendar vs. Timestamp
Date: 2006-04-11 17:28:44
Message-ID: 20060411172844.7305786B12@ws7-1.us4.outblaze.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Thanks.

--
_______________________________________________

Search for businesses by name, location, or phone number. -Lycos Yellow Pages

http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-04-11 20:08:23 Re: Calendar vs. Timestamp
Previous Message Andres Olarte 2006-04-11 01:51:15 Re: I just can't use the org.postgresql.Driver class... Please help!