timestamp with time zone >= character varying
解决处理办法 ,将时间转换成timestamp
Timestamp timestamp =null;
Timestamp timestamp1=null;
if(!ObjectUtil.isEmpty(startAt)){
timestamp = Timestamp.valueOf(startAt);
}
if(!ObjectUtil.isEmpty(endAt)){
timestamp1 = Timestamp.valueOf(endAt);
}
做完非空处理后进行转换
<if test="startAt!=null">
</if>
数据库判断处理的时间不能进行空字符串判断,否则会报错,去掉空字符串判断校验问题解决