Re: ResultSet#xxxTimestamp for DATE column unexpected behavior

From: "dircha" <dircha(at)dircha(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSet#xxxTimestamp for DATE column unexpected behavior
Date: 2005-09-22 22:06:49
Message-ID: 1127426809.877.243552739@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 22 Sep 2005 09:50:58 +1200, "Oliver Jowett"
<oliver(at)opencloud(dot)com> said:
> dircha wrote:
>
> > pgsql-jdbc version: postgres80-312-jdbc2.jar
>
> Please try the current CVS driver -- I made a number of fixes to
> timestamp handling in CVS recently.

I built the latest pgsql-jdbc from cvs HEAD and ran the previously
described tests again.

Both issues I mentioned appear to have been fixed; the behavior is
as expected.

Great.

Is there any word yet on which official build these changes might be
expected to be present in, in terms of the labeling used on the pgsql-
jdbc downloads page? Will there be another 8.0-xxx.jdbc3.jar, or would
these changes go into a forthcoming stable 8.1-xxx.jdbc3.jar?

For reference, the updated results of the previously described test
are below.

Thanks!

--dircha

-------BEGIN TEST DATE AS TIMESTAMP-----------
- Creating test.

- Inserting '2000-1-1' into test.

Retrieving date from test: 2000-01-01

Retrieving timestamp from test: 2000-01-01 00:00:00.0

Updating test with retrieved timestamp

Retrieving date from test: 2000-01-01

-------END TEST DATE AS TIMESTAMP------------------BEGIN TEST DATE AS
TIMESTAMP-----------
- Creating test.

- Inserting '3000-1-1' into test.

Retrieving date from test: 3000-01-01

Retrieving timestamp from test: 3000-01-01 00:00:00.0

Updating test with retrieved timestamp

Retrieving date from test: 3000-01-01

-------END TEST DATE AS TIMESTAMP----------- DONE

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Karl von Randow 2005-09-22 22:34:50 getColumnClassName() and getObject() types differ for smallint
Previous Message Kevin Grittner 2005-09-22 18:37:03 Re: [Fwd: Re: JDBC driver bug?]