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)) 将类型转换成字符类型