Solution hint value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp;

MySQL in the query times a

Value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp;

This error is due to the fact that it will insert ' 0000-00-00 00:00:00 ' when the default is to insert a time of type timestamp, but when the database is defined and because the design is a non-empty timestamp type, the query will be faulted. And the time frame for MySQL is: ' 1000-01-01 00:00:00‘ to '9999-12-31 23:59:59‘这个时间段，所以会报错，目前的解决办法是在jdbc连接文件中添加一句：

&zeroDateTimeBehavior=convertToNull

Url=jdbc:mysql://localhost:3306/seckill?useunicode=true&characterencoding=utf8&& Zerodatetimebehavior=converttonull

At present, this method is still useful, but in the back I do not know whether there will be new problems arise.

Solution hint value ' 0000-00-00 00:00:00 ' can not is represented as Java.sql.Timestamp;