Received: from mail.phoenixcolor.com (www.phoenixcolor.com [206.102.93.34]) by hub.org (8.10.1/8.10.1) with ESMTP id e5EK0w891057 for ; Wed, 14 Jun 2000 16:00:58 -0400 (EDT) Received: from phoenixcolor.com ([172.16.0.210]) by mail.phoenixcolor.com (Pro-8.9.3/Pro-8.9.3) with ESMTP id QAA03424 for ; Wed, 14 Jun 2000 16:04:57 -0400 Message-ID: <3947E3F4.1E015246@phoenixcolor.com> Date: Wed, 14 Jun 2000 15:58:44 -0400 From: John Thorhauer Organization: Phoenix Color Corporation X-Mailer: Mozilla 4.72 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/68 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 ********************************