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>