22,206
社区成员
发帖
与我相关
我的任务
分享
SET DATEFIRST 6
DECLARE @StartDate DATE='2017-07-14',@EndDate DATE='2017-07-24'
SELECT DATEPART(wk, DATEADD(d,sv.number,@StartDate)) AS 周数,MIN(DATEADD(d,sv.number,@StartDate)),MAX(DATEADD(d,sv.number,@StartDate))
FROM master.dbo.spt_values AS sv
WHERE sv.number BETWEEN 0 AND DATEDIFF(d,@StartDate,@EndDate) AND sv.type='P'
GROUP BY DATEPART(wk, DATEADD(d,sv.number,@StartDate))
SET DATEFIRST 7
周数 (No column name) (No column name)
28 2017-07-14 2017-07-14
29 2017-07-15 2017-07-21
30 2017-07-22 2017-07-24