select * from tableName where DATEPART(dd,日期字段)=DATEPART(dd,getDate())
昨天:
select * from tableName where DATEPART(dd,日期字段)=DATEPART(dd,DATEADD(day, -1, getDate())
本周:
select * from tableName where DATEPART(ww,日期字段)=DATEPART(ww,getdate())
当月:
select * from tableName where DATEPART(mm,日期字段)=DATEPART(mm,getdate())