where呢
没有where,还有这里应该是+'-21'
select convert(char(10),a.tj_date,120) from gc_production a where convert(date,a.tj_date) between format(dateadd(MM,-1,'2022-08-01'),'yyyy-MM-','21') and '2022-08-01'