参数是日期格式:2024-01,引用到数据集中,想要的格式为202401
SELECT * FROM STSCORE where zd='${replace(参数名,"-","")}'
------------
SELECT * FROM STSCORE where 1=1 ${if(len(参数名)==0,""," and zd='"+replace(参数名,"-","")+"'")}
直接
replace(控件名,"-","")
REPLACE("2024-01","-","")