java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04 - Mailing list pgsql-interfaces

From John Thorhauer
Subject java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
Date
Msg-id 3947E3F4.1E015246@phoenixcolor.com
Whole thread Raw
List pgsql-interfaces
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
********************************


pgsql-interfaces by date:

Previous
From: Jim Caley
Date:
Subject: Re: JDBC, Timestamps, and Fractions of a Second
Next
From: Jim Caley
Date:
Subject: Re: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04