--每天的喊话数据---
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)
转载于:https://www.cnblogs.com/dudu837/archive/2010/03/02/1676482.html