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