1.SQL语句
‘2460-08-05’ 是前天传递过来的字符串, 通过to_date函数进行转换
数据库中的date类型是 ‘2020-01-01 00:00:00’
select *
FROM TBL_PLAN
WHERE END_DATE <= to_date('2460-08-05','yyyy-mm-dd');
2.mybatis语句
<select >
select
*
from TBL_PLAN
where 1=1
<trim>
<if test="startDate !='' ">
AND t1.START_DATE <![CDATA[ >= ]]> to_date(#{startDate},'yyyy-mm-dd')
</if>
<if test="endDate !='' ">
AND t1.END_DATE <![CDATA[ <= ]]> to_date(#{endDate},'yyyy-mm-dd')
</if>
</trim>
</select>