How to Handle \'0000-00-00 00:00:00\' Timestamp Errors in Java JDBC?

Date Representation Error: '0000-00-00 00:00:00' in java.sql.Timestamp

In a MySQL database, a common issue arises when retrieving dates from a table that contains auto-assigned values of '0000-00-00 00:00:00'. This value cannot be represented as a java.sql.Timestamp object, resulting in the error: "'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp."

To address this issue without changing the table structure, modify the JDBC URL in your data source configuration. Add the following parameter to the URL:

?zeroDateTimeBehavior=convertToNull

For example:

jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull

This setting instructs the JDBC driver to convert '0000-00-00 00:00:00' to a NULL value, which can be handled without error. Note that this setting only affects JDBC operations and does not modify the data in the database.

The above is the detailed content of How to Handle \'0000-00-00 00:00:00\' Timestamp Errors in Java JDBC?. For more information, please follow other related articles on the PHP Chinese website!