In org.postgresql.jdbc2.ResultSet, both getDate() and getTime() fail on columns of type 'timestamp', which is against the jdbc spec, patch below fixes it. Michael Stephenson [EMAIL PROTECTED] Developer - Web Applications - Open World Tel: +44 1225 444 950 Fax: +44 1225 336 738 --- ResultSet.java.old Wed May 30 16:32:48 2001 +++ ResultSet.java Wed May 30 16:41:33 2001 @@ -423,6 +423,8 @@ String s = getString(columnIndex); if(s==null) return null; + if (s.length() > 10) + return new java.sql.Date(getTimeStamp(columnIndex).getTime()) return java.sql.Date.valueOf(s); } @@ -441,6 +443,8 @@ if(s==null) return null; // SQL NULL + if (s.length() > 8) + return new java.sql.Time(getTimeStamp(columnIndex).getTime()); return java.sql.Time.valueOf(s); } ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html