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 Conver ...
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)
