mybatis,mysql根据日期查询

数据库表的字段列 paymentDate varchar类型，传参时间段paymentDateBegin ,paymentDateEnd 

<if test=" paymentDateBegin !=null and paymentDateBegin !=''">

<![CDATA[
      and DATE_FORMAT(a.paymentDate, '%Y-%m-%d') >=  DATE_FORMAT(#{paymentDateBegin}, '%Y-%m-%d')
]]>
</if>

<if test=" paymentDateEnd !=null and paymentDateEnd !=''">
<![CDATA[
      and DATE_FORMAT(a.paymentDate, '%Y-%m-%d') <=  DATE_FORMAT(#{paymentDateEnd}, '%Y-%m-%d')
]]>
</if>