你的写法格式不对

参考下面的写法

select * from tb

where 1=1

${if(len(查询开始日期)=0,"","and 日期字段>='"+查询开始日期+"'")}

${if(len(查询结束日期)=0,"","and 日期字段<='"+查询结束日期+"'")}

改成

SELECT * FROM finance_data.ads_ly_erp_yuanliaojuanshengchantongji_table

WHERE DATE_FORMAT(lingliaoriqi, '%Y-%m-%d')>='${starttime}' and DATE_FORMAT(lingliaoriqi,

%Y-%m-%d')<'${endtime}'

${if(len(yuanliaojuanhao)== 0,"", "and yuanliaojuanhao = '"+ yuanliaojuanhao + "'")}