摘要: 1 本周数据:2 select * from Keywords where datediff(week, Addtime,getdate())=03 本月:4 select * from Keywords where datediff(month, Addtime,getdate())=05 本季度:6 select * from Keywords where datediff(quarter, Addtime,getdate())=07 本年:8 select * from Keywords where datediff(year, Addtime,getdate())=0 阅读全文
posted @ 2013-12-31 15:06 迷惘却坚定 阅读(100) 评论(0) 推荐(0) 编辑