MySQL solution value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp

Synchronous Release: Http://www.yuanrengu.com/index.php/mysqlsolvetimestamp.html

When using MySQL, if the field type in the database is timestamp, the default is 0000-00-00, an exception occurs: Value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp.

The solution is as follows:

Add the zerodatetimebehavior parameter to the jdbc.url of the database, as follows:

Jdbc.url=jdbc:mysql://Localhost:3306/table?characterencoding=utf-8&zerodatetimebehavior=round 

The zerodatetimebehavior parameter is configured in two ways:

• Zerodatetimebehavior=round, "0000-00-00" will be converted by default to "0001-01-01 00:00:00"
• Zerodatetimebehavior=converttonull, "0000-00-00" will be converted to null

MySQL solution value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp