sqlserver获取上月最后一天

47 阅读1分钟

sqlserver获取上月最后一天

```SELECT top 1 convert(nvarchar(10),dateadd(month,-1,getdate()),23) as '上个月的今天', 
        DATEADD(DAY, -1, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1))  as '上个月底'
FROM table