| week(ww,wk) | day(dd,dy) | hour(h) | minute(mi,n) |
second (ss,s)| millisecond(ms)
date 参数是合法的日期表达式...| day(dd,dy) | hour(h) | minute(mi,n) |
second (ss,s)| millisecond(ms)
startdate 和 enddate 参数是合法的日期表达式...--上周周一
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)...(yy, DATEDIFF(yy,0,getdate()), 0))
--.本月的第一个星期一
select DATEADD(wk,
DATEDIFF(wk