From: Dallas Hockley <hockleyd@cybersurf.net>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] jdbc, Dates, and JBuilder
Date: Thu, 25 Jun 1998 12:48:58 -0600
Message-ID: <35929B9A.3AEFF2FB@cybersurf.net> (raw)
References: <Pine.LNX.3.95.980625074612.7022E-100000@taer.maidstone.gov.uk>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hockleyd@cybersurf.net
Subject: Re: [INTERFACES] jdbc, Dates, and JBuilder
In-Reply-To: <35929B9A.3AEFF2FB@cybersurf.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox