Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group