小记存储过程中经常用到的本周，本月，本年函数［转］

本周

select Dateadd(wk,datediff(wk,0,getdate()),-1)                             
select Dateadd(wk,datediff(wk,0,getdate()),6)

本月

select Dateadd(mm,datediff(mm,0,getdate()),0)
select Dateadd(ms,-3,dateadd(mm,datediff(m,0,getdate())+1,0))

今年

select Dateadd(yy,datediff(yy,0,getdate()),0)
select Dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0))

转载于:https://www.cnblogs.com/tlnature/archive/2009/02/21/1395272.html