Hi, PostgreSQL 7 Beta 5 on Red hat Linux 6.0 JDBC 6.5-1.1 driver, Java 1.1.7B, download JDBC driver from http://www.retep.org.uk/postgres/ We have a a table which has a column col_a with 'timestamp' data type. When insert time value to this column, we use format which is 'MM/DD/YYYY HH24:MI:SS' (such as '05/01/2000 13:20:02'). Insertion is OK. But when we try to read this column, the output is '05/01/2000 13:20:02.20-04', which is not what we need. We don't need the '.20-04' part of the output, that is nano second and time zone part, otherwise the output cannot work with JDBC driver. Is there any ways make our app work without returning the 'nano and time zone' part or make JDBC understand the 'timestamp' full output format? Thnx! Error msg we got from running our app: " TAMP = 2000-04-03 00:00:00.0 GETTIME = 954734400000 DATE = Mon Apr 03 00:00:00 EDT 2000 Bad Timestamp Format at 0 in 2000-04-03 12:12:12.12-04 at postgresql.jdbc1.ResultSet.getTimestamp(ResultSet.java:445) at com.netcom.netforensics.dbaccess.SQLObjectAccess.getProperty(SQLObjectAccess .java:709) " Jack
