How to Properly Use setDate in PreparedStatement for Different Date and Timestamp Data Types?

Using setDate in PreparedStatement

In the code you provided, you want to insert a date value into a SQL table using a PreparedStatement. When using setDate(), it's important to understand the format of the date value that should be passed.

Using java.sql.Date

For columns of type DATE, you have several options when setting the value using java.sql.Date:

• java.lang.String: The string representing the date must be in the format "yyyy-MM-dd."
• java.util.Date: Convert the java.util.Date to a java.sql.Date using new java.sql.Date(endDate.getTime()).
• Current timestamp: Use new java.sql.Date(System.currentTimeMillis()) to set the current date.

Using java.sql.Timestamp

For columns of type TIMESTAMP or DATETIME, use java.sql.Timestamp:

• java.lang.String: The string representing the timestamp must be in the format "yyyy-MM-dd HH:mm:ss[.f...]."
• java.util.Date: Convert the java.util.Date to a java.sql.Timestamp using new java.sql.Timestamp(endDate.getTime()).
• Current timestamp: Use new java.sql.Timestamp(System.currentTimeMillis()) to set the current timestamp.

In your case, ensure that the vDateMDY string is in the correct format, "yyyy-MM-dd HH:mm:ss." If it is not, you will need to use the appropriate format for your SQL column data type or consider using setString() and a to_date() conversion in the SQL statement itself.

The above is the detailed content of How to Properly Use setDate in PreparedStatement for Different Date and Timestamp Data Types?. For more information, please follow other related articles on the PHP Chinese website!