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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to