MySQL date type '2017-00-00 'Problem

MySQL date type '2017-00-00 'problem when using mysql to query the datetime ing field of datetime type value '2017-00-00 00:00:00' will throw an exception and many people may encounter same problem, this exception occurs when access is performed through JDBC: Java code java. SQL. SQLException: Value '2014-00-00' can not be represented as java. SQL. timestamp solution: add the zeroDateTimeBehavior parameter to the jdbc url: datasource. url = jdbc: mysql: // localhost: 3306/testdb? UseUnicode = true & characterEncoding = UTF-8 & zeroDateTimeBehavior = convertToNull & transformedBitIsBoolean = true zeroDateTimeBehavior = round is used to specify the processing method for querying DateTime fields in MySql by default. An exception is thrown by default, for records with a value of 0000-00-00 00:00:00 (default), the following two types of configuration return different results: zeroDateTimeBehavior = round 0001-01-01 00:00:00. 0 zeroDateTimeBehavior = convertToNull null