Message-ID: <35929B9A.3AEFF2FB@cybersurf.net>
Date: Thu, 25 Jun 1998 12:48:58 -0600
From: Dallas Hockley <hockleyd@cybersurf.net>
Organization: Cybersoft Communications Software Inc.
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] jdbc, Dates, and JBuilder
References: <Pine.LNX.3.95.980625074612.7022E-100000@taer.maidstone.gov.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Peter Mount wrote:
> 
> On Wed, 24 Jun 1998, Dallas Hockley wrote:
[snip]
> 
> This is an old Java bug that I thought I had got rid of. The
> java.util.Date class seems to loose a day somewhere in the conversion
> (at least this is with JDK1.1.3 which I still use).
> 
> > Has anyone experienced similar behaviour, or has anyone got a definitive
> > "it can't be ..... because.... "
> 
> No, it's definitley in there.
> 
> I thought I had got rid of it by adding one to the day in ResultSet... it
> looks like I'll have to add "fix Date support" to the list of things to
> work on again.
> 

Thanks for the quick reply Peter, although there is one thing I forgot
to mention.  

It appears the conversion on the insert is where the glitch was
introduced, as psql returns the altered date as well as a jdbc query. 
The two are in agreement, but they are both not correct with respect to
the data that was inserted.

I will upgrade the driver though.... thanks.


Dallas

hockleyd@cybersoft.ab.ca

> --
> Peter Mount, peter@maidstone.gov.uk
> Postgres email to peter@taer.maidstone.gov.uk & peter@retep.org.uk
> Remember, this is my work email, so please CC my home address, as I may
> not always have time to reply from work.