${IF(len(pv1)==0,"","and t.FDATE >=" +"to_date(pv1,'YYYY-MM-DD')")}
${IF(len(pv2)==0,"","and t.FDATE <=" + "to_date(pv2,'YYYY-MM-DD')")}
我是这样写的,一直报错,pv1和pv2是字符串类型的日期格式,FDATE是日期类型 的
你是oracel数据库?
where 1=1
${if(len(pv1)=0,"","and trunc(t.FDATE)>=trunc(to_date('"+pv1+"','yyyy-mm-dd'))")}
${if(len(pv2)=0,"","and trunc(t.FDATE)<=trunc(to_date('"+pv2+"','yyyy-mm-dd'))")}
FDATE 和PV1,PV2格式一样就行
${IF(len(pv1)==0,"","and t.FDATE >='"+pv1+"')}
${IF(len(pv1)==0,"","and t.FDATE <='"+pv2+"')}
${IF(len(pv1)==0,"","and t.FDATE >='" +to_date(pv1,'YYYY-MM-DD')+"'")}
可以用convert