SQLSERVER根据第几周取得星期几的日期
DECLARE @ZHOUSHU INT --第几周
SET @ZHOUSHU = 2
SELECT DATEADD(wk,DATEDIFF(wk,0,dateadd(wk, @ZHOUSHU, DATENAME(yy,getdate())+'-01-01')), 0) - 7 --星期一
SELECT DATEADD(wk,DATEDIFF(wk,0,dateadd(wk, @ZHOUSHU, DATENAME(yy,getdate())+'-01-01')), 0) - 2 --星期六
SELECT DATEADD(wk,DATEDIFF(wk,0,dateadd(wk, @ZHOUSHU, DATENAME(yy,getdate())+'-01-01')), 0) - 1 --星期天