select * from OTO_Log where ActiveTime Like '%Year-Month-Day%' 上面这个根本就不对,这是比较字符串,日期不能这样比较字符串转日期类型用cast select * from OTO_Log where ActiveTime > cast('year-moth-day' as datetime)
select datename(week,ActiveTime) myweek , count(*) from OTO_Log where convert(varchar(7),ActiveTime,120) = '2008-01' group by datename(week,ActiveTime)
函數convert
select * from OTO_Log where ActiveTime > cast('year-moth-day' as datetime)
from OTO_Log where convert(varchar(7),ActiveTime,120) = '2008-01'
group by datename(week,ActiveTime)