本周.
select dateadd(day,7-datepart(weekday,getdate())+1,getdate())
select dateadd(day,1-datepart(weekday,getdate())+1,getdate())
本月
select * from tablename
where PorceDate>=convert(varchar(7),getdate(),120)+'-01'
and PorceDate<dateadd(month,1,convert(varchar(7),getdate(),120)+'-01')
本年
select * from tablename
where PorceDate>=datename(year,getdate())+'-01-01'
and PorceDate<dateadd(year,1,datename(year,getdate())+'-01-01')