多了括号
参考下面的写法
${if(len(starttime) == 0,"","and A.Transaction_TIME >= '" +starttime+ "'")}
${if(len(endtime) == 0,"","and A.Transaction_TIME <= '" +endtime+ "'")}
==============
改成个下面的格式试试
${if(len(starttime) == 0,"","and to_char(A.Transaction_TIME,'yyyy-mm-dd') >= '" +starttime+ "'")}
${if(len(endtime) == 0,"","and to_char(A.Transaction_TIME,'yyyy-mm-dd') <= '" +endtime+ "'")}