mybatis中两个时间段之间的查询
between and 没有实现想要的功能换成此方法解决
select
<include refid="Base_Column_List" />
from SVIP
where DELETE_FLAG != 1 and SVIP_STATUS =#{record.svipStatus} and RESERVE1 = #{record.reserve1} and TIME_ADD <![CDATA[>=]]> #{record.reserve11} and TIME_ADD <![CDATA[<=]]> #{record.reserve12}