MyBatis版本:2.1.1
OK!
<if test="detection.collectTimeStart != null and detection.collectTimeStart!='' ">
and DATE(collectTime) <![CDATA[>=]]> #{detection.collectTimeStart}
</if>
<if test="detection.collectTimeEnd != null and detection.collectTimeEnd!='' ">
and DATE(collectTime) <![CDATA[<=]]> #{detection.collectTimeEnd}
</if>
NO OK!
<if test="detection.collectTimeStart != null and detection.collectTimeStart!='' ">
and DATE(collectTime) >= #{detection.collectTimeStart}
</if>
<if test="detection.collectTimeEnd != null and detection.collectTimeEnd!='' ">
and DATE(collectTime) <= #{detection.collectTimeEnd}
</if>