获取一个参数之后,如:&period_id=2020-10实际要的是2020-09这个日期条件计算要怎么写才正确呢其中year_id是varchar类型 month_id也是varchar类型select* from XXXXXXXXXXXwhere year_id='${period_id}' and yeardelta(date '${period_id}',-1)select* from XXXXXXXXXXXwhere month_id='${period_id}' and monthdelta(date '${period_id}',-1)