I want to get all entries from a table in db2 where a certain timestamp is not set. If I use a query "select something, myTimestamp from myTable", and I print myResultSet.getTimeStamp("myTimestamp"), the answer is null;
However, if I try to select all the empty timestamps with a preparedStatement: preparedStatement = "select something from myTable where myTimestamp=?"; preparedStatement.setTimeStamp(1, null); I do not get any results! Does anybody know how can I find the empty timestamps?