mybatis 时间区间查找 req.startTime -> date类型
<if test="req.startTime != null and req.endTime != null">
<![CDATA[
and DATE_FORMAT(ivo.created , '%Y-%m-%d')>= DATE_FORMAT(#{req.startTime}, '%Y-%m-%d')
]]>
<![CDATA[
and DATE_FORMAT(ivo.created , '%Y-%m-%d')<= DATE_FORMAT(#{req.endTime}, '%Y-%m-%d')
]]>
</if>