Mysql：参数格式异常 Zero date value prohibited

解决办法

找到数据库中的不符合日期格式的字段并删掉该数据 , 或者修改日期格式。我出现的原因就是数据库表里 一条数据有里的日期字段为00:00:00:00:00，导致查询时返回失败。

贴出异常信息

Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: Error attempting to get column 'startDay' from result set.  Cause: java.sql.SQLException: **Zero date value prohibited**
; Zero date value prohibited; nested exception is java.sql.SQLException: Zero date value prohibited] with root cause
com.mysql.cj.exceptions.DataReadException: Zero date value prohibited
	at com.mysql.cj.result.SqlDateValueFactory.createFromDate(SqlDateValueFactory.java:72)
	at com.mysql.cj.result.SqlDateValueFactory.createFromDate(SqlDateValueFactory.java:46)
	at com.mysql.cj.result.BaseDecoratingValueFactory.createFromDate(BaseDecoratingValueFactory.java:53)
	at com.mysql.cj.result.BaseDecoratingValueFactory.createFromDate(BaseDecoratingValueFactory.java:53)
........