把时间转换成你要的格式

 

SELECT cast(DATEPART(yy, '') AS varchar)+'-'+ cast(DATEPART(mm, '2009-6-15 15:29:40') AS varchar) AS 'Month Number'