Mysql datetime query exception troubleshooting, mysqldatetime Query

Mysql datetime query exception troubleshooting, mysqldatetime Query

An error occurred while querying mysql datetime.

1. Exception: Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp (0000 11:38:40)
2. Description: non-null Datetime type field without default Value. The program reports the following error during query: Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp
3. Solution: add the zeroDateTimeBehavior parameter to the database connection string or the noDatetimeStringSync parameter jdbc: mysql: // host: port/xxx ?...

ZeroDateTimeBehavior: value exception, converToNull, and round

1. Exception --- throw an exception: the result is java. SQL. SQLException: Value '2017-00-00 00:00:00 'can not be represented as java. SQL. Timestamp.
2. ConverToNull: returns a null value.
3. Round: 0001-01-01 00:00:00. 0 is returned.
   

NoDatetimeStringSync: If set to true, 0000-00-00 00:00:00 is returned.

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!