Message-ID: <394A2599.76380445@chesco.com>
Date: Fri, 16 Jun 2000 09:03:21 -0400
From: Jim Caley <caley@chesco.com>
MIME-Version: 1.0
To: John Thorhauer <jthorhauer@phoenixcolor.com>
CC: pgsql-interfaces@postgresql.org
Subject: Re: java.sql.SQLException: Bad Timestamp Format at 19 in
	2000-06-14 15:48:18.80-04
References: <3947E3F4.1E015246@phoenixcolor.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi John,

We've been discussing this very issue on this mailing list over the past
couple of days.  If you go to
http://www.postgresql.org/mhonarc/pgsql-interfaces/2000-06/threads.html
and search the page for "Timestamps" you'll see the thread (actually, I
just checked, and at the moment the thread is right at the top of the
page).  The first message in the thread includes a patch that's been
working for me.

HTH

Regards,
Jim
--

John Thorhauer wrote:
> 
> I am using postgres 7.0 and and jdbc driver ver 7.0 on linux and am
> getting the following error:
> 
> Exception: java.sql.SQLException: Bad Timestamp Format at 19 in
> 2000-06-14 15:48:18.80-04
> 
> If I edit my the timestamp field in my table and change the data from
> '2000-06-14 10:04:47.13-04' to '2000-06-14 10:04:47'  everything seems
> to work fine.
> 
> I tried using the 6.5-1.2 jdbc and got the same result.
> Can anyone help me with this?
> 
> Thanks,
> John Thorhauer
> --
> ********************************
> ** John Thorhauer
> ** Web Developer
> ** Phoenix Color Corp.
> ** jthorhauer@phoenixcolor.com
> ********************************