Using setDate in PreparedStatement

❐ Using java.sql.Date

If your table has a column of type DATE:

• java.lang.String

  The method java.sql.Date.valueOf(java.lang.String) received a string representing a date in the format yyyy-[m]m-[d]d. e.g.:

  ps.setDate(2, java.sql.Date.valueOf("2013-09-04"));
  

• java.util.Date

  Suppose you have a variable endDate of type java.util.Date, you make the conversion thus:

  ps.setDate(2, new java.sql.Date(endDate.getTime());
  

• Current

  If you want to insert the current date:

  ps.setDate(2, new java.sql.Date(System.currentTimeMillis()));
  
  // Since Java 8
  ps.setDate(2, java.sql.Date.valueOf(java.time.LocalDate.now()));
  

❐ Using java.sql.Timestamp

If your table has a column of type TIMESTAMP or DATETIME:

• java.lang.String

  The method java.sql.Timestamp.valueOf(java.lang.String) received a string representing a date in the format yyyy-[m]m-[d]d hh:mm:ss[.f...]. e.g.:

  ps.setTimestamp(2, java.sql.Timestamp.valueOf("2013-09-04 13:30:00");
  

• java.util.Date

  Suppose you have a variable endDate of type java.util.Date, you make the conversion thus:

  ps.setTimestamp(2, new java.sql.Timestamp(endDate.getTime()));
  

• Current

  If you require the current timestamp:

  ps.setTimestamp(2, new java.sql.Timestamp(System.currentTimeMillis()));
  
  // Since Java 8
  ps.setTimestamp(2, java.sql.Timestamp.from(java.time.Instant.now()));
  ps.setTimestamp(2, java.sql.Timestamp.valueOf(java.time.LocalDateTime.now()));