摘要:
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 阅读全文