select count(*) from table where createdate >= date(now());
select count(*) from table where createdate >= date_add(date(now()), interval -1 day) and createdate < date(now());
//昨天
select count(1) as yesterday from XX where datediff(d,ProgDate,getdate())=1
//今天
select count(1) as today from XX where datediff(d,ProgDate,getdate())=0
date 今天零点=now.date
date 昨天零点=今天零点.adddays(-1)
select * from table where createdate >= 昨天零点 and createdate < 今天零点
select * from table where createdate >= 今天零点
select convert(varchar(7),ViewDate,120) as month, COUNT(1) as NUM, from PageView
group by convert(varchar(7),ViewDate,120)
order by month desc
我是根据月份来取的 比如 3月10条 4月20条....