获取当天:
select * from t_User_Video where datediff(DAY,AddDate,getdate())=0
获取本周:
select * from t_User_Video where datediff(week,AddDate,getdate())=0
AddDate 为时间类型的字段
获取本月:
select * from t_User_Video where datediff(MONTH,AddDate,getdate())=0
获取本季:
select * from t_User_Video where datediff(qq,AddDate,getdate())=0