摘要:
本周select*fromtbwheredatediff(week,时间字段,getdate())=0上周select*fromtbwheredatediff(week,时间字段,getdate())=1下周select*fromtbwheredatediff(week,时间字段,getdate())=-1-------------------------------------------------------------------------------------------------------------------------------------------------- 阅读全文