摘要: 本周select*fromtbwheredatediff(week,时间字段,getdate())=0上周select*fromtbwheredatediff(week,时间字段,getdate())=1下周select*fromtbwheredatediff(week,时间字段,getdate())=-1-------------------------------------------------------------------------------------------------------------------------------------------------- 阅读全文
posted @ 2012-07-04 22:40 威少 阅读(537) 评论(0) 推荐(0) 编辑