MySQL时间戳比较查询报错

Zero date value prohibited

后面追加上

&zeroDateTimeBehavior=convertToNull

3306/db_project?serverTimezone= GMT%2B8&zeroDateTimeBehavior=convertToNull

[java.util.Date] for value ‘2020-12-12 12:12:12’; nested exception is java.lang.IllegalArgumentException;

实体前加上格式

@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date putTime;

xml中最好也格式化一下

<if test=" null !=putTime">
				and out_time &gt;= DATE_FORMAT(#{putTime,jdbcType = TIMESTAMP},'%Y-%m-%d %H:%i::%s')
</if>