1 AND SUBSTR(a.dd,0,4) = '2023'
2 ${IF(LEN($SMM)==0,""," and SUBSTR(a.dd,0,4)='"+left($SMM,4)+"'")}
1是原来的,2是想要把日期参数的值,当成年传参过来,表里的字段需要截取,没起作用
${IF(LEN(SMM)==0,""," and SUBSTR(a.dd,0,4)='"+left(SMM,4)+"'")}
========
${}中不需要$
日期类的函数可以尝试使用year(a.dd)获取年份,或者使用to_char(a.dd,'yyyy')转正字符串获取年份。当然你这个的我中$sum中应该把$符号去掉