如果数据库直接是varchar2类型,保存格式是yyyy-MM-dd的话,不需要to_date函数
直接写
select * fom ST_ZZYHRZBWLWXMX
where 1=1 and REGION_CITY_ID='${csid}'
if{len(starttime)=0,""," and TJRQ>='"+format(starttime,"yyyy-MM-dd")+"'"}
if{len(endtime)=0,""," and TJRQ>='"+format(endtime,"yyyy-MM-dd")+"'"}