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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
