I would like to bring this up again, since - it seems like a genuine bug to me (violation of standard) - it is still present in v0.44 - it is probably very easy to fix
Already reported: http://groups.google.com/group/sqlitejdbc/browse_thread/thread/473e8e6bd21de80a ResultSet.getDate()/getTime()/getTimestamp() functions do not return null values if the corresponding column is SQL NULL. This is in contradiction to http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html which states for those functions: "if the value is SQL NULL, the value returned is null in the Java programming language" Example: Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery("select NULL;"); while (rs.next()) { System.out.println("date: " + rs.getDate(1)); System.out.println("time: " + rs.getTime(1)); System.out.println("timestamp: " + rs.getTimestamp(1)); } returns: date: 1970-01-01 time: 01:00:00 timestamp: 1970-01-01 01:00:00.0 Expected result: date: null time: null timestamp: null --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---