摘要： 12/**//*计算今天是星期几*/3select datename(weekday,getdate()) 45/**//*查询本年的数据*/6select * from users where year(time)=year(getdate()) 78/**//*查询本月的数据，time是表users中代表时间的字段*/9select * from users where month(time)... 阅读全文