select * from tabname 
where 1=1 
${if(len(start_date)=0 && len(end_date)=0,""," and TO_CHAR(O.Requestedshipdate, 'yyyy-mm-dd') >= '"+start_date+"' and TO_CHAR(O.Requestedshipdate, 'yyyy-mm-dd') <= '"+end_date+"'")}
-- 日期前后类型注意统一格式；
${if(len(wbdh) =0,""," and O.EXTERNORDERKEY IN ('"+wbdh+"')")}
${if(len(wlbm) =0,""," and OD.SKU IN ('"+wlbm+"')")} 
${if(len(scdd) =0,""," and o.notes IN ('"+scdd+"')")} 
${if(len(ckdlx)=0,""," and ot.description IN ('"+ckdlx+"')")}

where 1=1 

${if(len(start_date)==0," ","and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi') >= '"+start_date+"'")}

${if(len(end_date)==0," ","and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi') <= '"+end_date+"'")}

${if(len(wbdh)==0,"","and O.EXTERNORDERKEY in('"+wbdh+"')")} 

${if(len(wlbm)==0,"","and OD.SKU in('"+wlbm+"')")} 

${if(len(scdd)==0,"","and o.notes in('"+scdd+"')")} 

${if(len(ckdlx)==0,"","and ot.description in('"+ckdlx+"')")}

where 1=1 ${if(len(start_date)=0 && len(end_date)=0,""," and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi')")}

${IF(LEN(start_date)=0,"","AND TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi')  >=('"+STARTDATE+"')")}

${IF(LEN(end_date)=0,"","and TO_CHAR(O.Requestedshipdate + '8 / 24', 'yyyy-mm-dd hh24:mi')  <=('"+end_date+"')")}

${if(len(wbdh)==0,"","and O.EXTERNORDERKEY in('"+wbdh+"')")} ${if(len(wlbm)==0,"","and OD.SKU in('"+wlbm+"')")} ${if(len(scdd)==0,"","and o.notes in('"+scdd+"')")} ${if(len(ckdlx)==0,"","and ot.description in('"+ckdlx+"')")}

改成这个就可以用了