Mysql solves Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp, mysqltimestamp0000

Mysql solves Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp, mysqltimestamp0000

 

Synchronous publishing: http://www.yuanrengu.com/index.php/mysqlsolvetimestamp.html

When using mysql, if the field type in the database is timestamp, the default value is 0000-00-00, an exception occurs: value '2017-00-00 00:00:00 'can not be represented as java. SQL. timestamp.

The solution is as follows:

Add jdbc. url to the databaseZeroDateTimeBehaviorParameters:

Jdbc. url = jdbc: mysql: // localhost: 3306/table? CharacterEncoding = UTF-8 & zeroDateTimeBehavior = round

ZeroDateTimeBehaviorThere are two types of parameters:

• ZeroDateTimeBehavior = round, "" is converted to "0001-01-01 00:00:00" by default"
• ZeroDateTimeBehavior = convertToNull, "bytes -00-00" will be converted to null