SQL月度统计

select convert ( varchar(7),createtime,120) as date ,sum(money) as m from [lbammeterdb].[dbo].am_task
where operatetype=4 and status=1
group by convert ( varchar(7), createtime, 120)