如下
<if test="starttime != null and starttime != ''">
AND STR_TO_DATE(a.create_time,'%Y-%m-%d') >= #{starttime}
</if>
<if test="endtime != null and endtime != ''">
AND #{endtime} >= STR_TO_DATE(a.create_time,'%Y-%m-%d')
</if>
如下
<if test="starttime != null and starttime != ''">
AND STR_TO_DATE(a.create_time,'%Y-%m-%d') >= #{starttime}
</if>
<if test="endtime != null and endtime != ''">
AND #{endtime} >= STR_TO_DATE(a.create_time,'%Y-%m-%d')
</if>