--上周周一
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()),-7)
--上周周天
SELECT DATEADD(wk, DATEDIFF...dateadd(wk,datediff(wk,0,getdate()),6)
--下周周一
select dateadd(wk,datediff(wk,0,getdate()),7)...--下周周天
select dateadd(wk,datediff(wk,0,getdate()),13)
--1.本月第一天
SELECT DATEADD(mm, DATEDIFF...select dateadd(wk,datediff(wk,0,getdate()),6)
--.本年第一天
SELECT DATEADD(yy, DATEDIFF...(yy, DATEDIFF(yy,0,getdate()), 0))
--.本月的第一个星期一
select DATEADD(wk,
DATEDIFF(wk