只需要借助Date——Format,在此记录一下
<if test="updateTime != null ">
<![CDATA[ AND DATE_FORMAT(update_time, '%Y-%m-%d') = DATE_FORMAT(#{updateTime,jdbcType=DATE},'%Y-%m-%d')]]>
</if>
<if test="createTime != null ">
<![CDATA[ AND DATE_FORMAT(create_time, '%Y-%m-%d') = DATE_FORMAT(#{createTime,jdbcType=DATE},'%Y-%m-%d')]]>
</if>