Message-ID: <3591C741.93633F87@cybersurf.net>
Date: Wed, 24 Jun 1998 21:42:57 -0600
From: Dallas Hockley <hockleyd@cybersurf.net>
Organization: Cybersoft Communications Software Inc.
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: jdbc, Dates, and JBuilder
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Got a wee problem here, and I'm having a devil of a time locking it
down....

Using 6.3.1 Postgresql, with the accompanying jdbc driver, and using
Jbuilder 1.01 and 2.0, I am reading in a string, converting it to
a valid and correct sql.date, putting that into a DataRow instance 
(Borland class) and committing the row to the database.  The data is
correct in the data row as it prepares for the commit.  

After insert, when the row is retrieved, the day is consistently 1 too
large.  e.g. 04-14-1998 becomes 04-15-1998 after it's been committed via
the jdbc driver.  What I'm not sure of is if it's the driver, the
database, the datarow class or some interface between two of them.

Has anyone experienced similar behaviour, or has anyone got a definitive
"it can't be ..... because.... "

I'd appreciate any assistance on this.

Thanks in advance,

Dallas Hockley
hockleyd@cybersoft.ab.ca