Java Timestamp in SQL

// DO NOT DO THIS!
// BUG: loses time of day
preparedStatement.setDate(1, new java.sql.Date(date.getTime()));


// DO THIS
preparedStatement.setTimestamp(1, new
java.sql.Timestamp(date.getTime()));
// java.sql.Timestamp is not a date


// MORE INFO GO TO
http://www.thunderguy.com/semicolon/2003/08/14/java-sql-date-is-not-a-real-date/


// GET BACK timestamp from DB

// result set


java.sql.Timestamp timestamp = resultSet.getTimestamp(1);
java.util.Date d = new java.util.Date(timestamp.getTime() +
timestamp.getNanos() / 1000000


or

// Java 1.4+
java.util.Date d = resultSet.getTimestamp(1);

.