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

From: John Thorhauer <jthorhauer(at)phoenixcolor(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
Date: 2000-06-14 19:58:44
Message-ID: 3947E3F4.1E015246@phoenixcolor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)phoenixcolor(dot)com
********************************

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jim Caley 2000-06-14 21:27:02 JDBC, Timestamps, and Fractions of a Second
Previous Message Vincent Trussart 2000-06-14 18:41:54 Postgres JDBC driver : problem with timestamps.