sqlserver获取上月最后一天 Jh918 2024-10-15 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