--查询给定时间所在周第一天
Select DATEADD(wk, DATEDIFF(wk,0,getDate()),0)
--本周第七天
Select DATEADD(wk, DATEDIFF(wk,0,getDate()),7)
--上周礼拜一
Select DATEADD(wk, DATEDIFF(wk,0,#),-7)
--查询给定时间所在周第一天
Select DATEADD(wk, DATEDIFF(wk,0,getDate()),0)
--本周第七天
Select DATEADD(wk, DATEDIFF(wk,0,getDate()),7)
--上周礼拜一
Select DATEADD(wk, DATEDIFF(wk,0,#),-7)