-- 参考脚本,自行扩展!
select * from tabname where 1=1
${if(len(KK)=0,""," and RQ >= '"+DATEINQUARTER(CONCATENATE(KK,"-01"),1)+"'"+" and RQ
——————————————————————————————————————
更新内容: KK 赋值 2022-01 截图如下
select * from tabname where 1=1
${if(len(KK)=0,""," and RQ >= '"+DATEINQUARTER(CONCATENATE(KK,"-01"),1)+"'"+" and RQ <= '"+DATEINMONTH(CONCATENATE(KK,"-01"),-1)+"'")}