This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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?