将字符串20081减去一个月

CAST(YEAR(DATEADD(dd, 1, DATEADD(mm, - 1, A.COSTMONTH + '-01')
                      - DAY(A.COSTMONTH + '-01'))) AS varchar) + '-' + CAST(MONTH(DATEADD(dd, 1, DATEADD(mm, - 1, A.COSTMONTH + '-01') - DAY(A.COSTMONTH + '-01')))
                       AS varchar)
原文地址:https://www.cnblogs.com/doc/p/1403973.html