Timestamp problem - Mailing list pgsql-jdbc

From Raymond Chui
Subject Timestamp problem
Date
Msg-id 3F1452EE.7000509@noaa.gov
Whole thread Raw
Responses Re: Timestamp problem
List pgsql-jdbc
I am use PostgreSQL 7.2.1 in Redhat Linux 7.2
Java 1.4.x

When I do JDBC

String sql = "SELECT datetime_column FROM mytable";
....

Timestamp ts = resultSet.getTimestamp(2);

If the timestamp return format like

2003-07-15 13:20:00.20+00

then is OK. But if timestamp return like

2003-07-15 13:20:00.421+00

Then I got SQLException

Bad Timestamp Format at 23 in 2003-07-14 14:45:00.421+00

What is 23?
How do I resolve this problem?

Thank Q!

--
Raymond Chui
NWS at NOAA
301-713-0640 ext 168



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: setFetchSize()
Next
From: "Pedro Galan"
Date:
Subject: Problems with Spanish Chars