获得日期的月份转换成字符显示

select cast(DATEPART(MM,m_startdate) as varchar(20)) as mdate,count(mno) as meetCount,sum(m_plannum+m_rznum+m_mealnum) as peopers,sum(datediff(day,m_startdate,m_enddate)) as days

from meet_base
where m_startdate is not null and m_level='普通'
group by cast(DATEPART(MM,m_startdate) as varchar(20))

得到日期的月份DATEPART(MM,m_startdate) as varchar(20)) 返回的是一个int的数据
                       yyyy

cast(DATEPART(MM,m_startdate) as varchar(20)) 将类型转换成字符类型