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]
-~----------~----~----~----~------~----~------~--~---

Reply via email to