--每天的喊话数据---
select CONVERT(char(10), CreateTime, 120),count(*) from [dbvs-mlg].[pingcoapp].appleGrange.Notice where CreateTime>'2/28/2010' and createtime<='3/3/2010' group by CONVERT(char(10), CreateTime, 120)
--每天的喊话数据---
select CONVERT(char(10), CreateTime, 120),count(*) from [dbvs-mlg].[pingcoapp].appleGrange.Notice where CreateTime>'2/28/2010' and createtime<='3/3/2010' group by CONVERT(char(10), CreateTime, 120)