在mssql中获取当月的第一周、第二周、第三周的日期，下一个月是什么日期？

-- 获取当月的第一周的日期
SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0) AS FirstWeekStartDate,
       DATEADD(DAY, 6, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0)) AS FirstWeekEndDate;

-- 获取当月的第二周的日期
SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) + 1, 0) AS SecondWeekStartDate,
       DATEADD(DAY, 6, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) + 1, 0)) AS SecondWeekEndDate;

-- 获取当月的第三周的日期
SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) + 2, 0) AS ThirdWeekStartDate,
       DATEADD(DAY, 6, DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()) + 2, 0)) AS ThirdWeekEndDate;

-- 计算下一个月的日期
SELECT DATEADD(MONTH, 1, GETDATE()) AS NextMonthDate;