select * from 表 group by year(你的时间列),month(你的时间列) order by year(你的时间列),month(你的时间列)
select cast(year('2003-09-23') as varchar(4)) select cast(month('2003-09-23') as varchar(2))select cast(datepart(yy,'2003-09-23') as varchar(4)) select cast(datepart(mm,'2003-09-23') as varchar(2))上面显示结果都是字符串形式
group by year(你的时间列),month(你的时间列)
order by year(你的时间列),month(你的时间列)
select cast(month('2003-09-23') as varchar(2))select cast(datepart(yy,'2003-09-23') as varchar(4))
select cast(datepart(mm,'2003-09-23') as varchar(2))上面显示结果都是字符串形式
select @yearmonth=convert(char(6),getdate(),112)