SQL 查询时间
1 本周数据: 2 select * from Keywords where datediff(week, Addtime,getdate())=0 3 本月: 4 select * from Keywords where datediff(month, Addtime,getdate())=0 5 本季度: 6 select * from Keywords where datediff(quarter, Addtime,getdate())=0 7 本年: 8 select * from Keywords where datediff(year, Addtime,getdate())=0