MyBatis时间比较 

<if test="submitTime!=null and submitTime!=''">
	AND DATE_FORMAT(sc.submit_time, '%Y-%m-%d') = DATE_FORMAT(#{submitTime}, '%Y-%m-%d')
</if>
<if test="correctTime!=null and correctTime!=''">
	AND DATE_FORMAT(sc.correct_time, '%Y-%m-%d') = DATE_FORMAT(#{correctTime}, '%Y-%m-%d')
</if>
posted @ 2018-12-26 17:03  灯塔下的守望者  阅读(641)  评论(0)  编辑  收藏  举报