本月
DATEDIFF(m,日期,GETDATE()) = 0
本周
DATEDIFF(ww,日期,GETDATE()) = 0
见此处
http://www.foxtable.com/help/index.html?n=1508.htm