(SUBSTR(to_CHAR(PREDICT_START_DAY,'YYYYMMDD'), 0, 6) between '${year1}' and '${year2}')--预计项目开始时间
应该是截取4个字符把
(SUBSTR(to_CHAR(PREDICT_START_DAY,'YYYYMMDD'), 0, 4) between '${year1}' and '${year2}')
${if(and(len(year1)>0,len(year2)>0),"SUBSTR(to_CHAR(PREDICT_START_DAY,'YYYYMMDD'), 0, 4) between '"+year1+"' and '"+year2+"'","")}