Обсуждение: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
От
John Thorhauer
Дата:
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 ********************************
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 > ********************************