pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedjava.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
2+ messages / 2 participants
[nested] [flat]
* java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
@ 2000-06-14 19:58 John Thorhauer <jthorhauer@phoenixcolor.com>
2000-06-16 13:03 ` Re: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04 Jim Caley <caley@chesco.com>
0 siblings, 1 reply; 2+ messages in thread
From: John Thorhauer @ 2000-06-14 19:58 UTC (permalink / raw)
To: 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
********************************
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04
2000-06-14 19:58 java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04 John Thorhauer <jthorhauer@phoenixcolor.com>
@ 2000-06-16 13:03 ` Jim Caley <caley@chesco.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jim Caley @ 2000-06-16 13:03 UTC (permalink / raw)
To: John Thorhauer <jthorhauer@phoenixcolor.com>; +Cc: pgsql-interfaces
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
> ********************************
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-06-16 13:03 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-14 19:58 java.sql.SQLException: Bad Timestamp Format at 19 in 2000-06-14 15:48:18.80-04 John Thorhauer <jthorhauer@phoenixcolor.com>
2000-06-16 13:03 ` Jim Caley <caley@chesco.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox