使用MONTHDELTA不成功,数据库是Mysql, 大神们帮忙找下问题呢,谢谢! SELECT ${switch(维度, "月","MONTHDELTA(date(last_update_date),-1)")} '时间', entirety_ppk FROM `pspc_ppk_report` where last_update_date between '${datedelta(today(),-365)}' and '${today()}' and ce_parameter ='THICK_DIFF_FAE_REDGE5' and attachment_resource = 'TMJIV002' and ppk_interval_type = '1' group by ${switch(维度, "月","MONTHDELTA(date(last_update_date),-1)")} |