select count(*) from tb where left(datetime,7)='2006-03'; 或 select count(*) from tb where datetime between '2006-03-01' and adddate('2006-03-01',interval 1 month);分钟小时天基本上就是这个样子了,
select count(*) from tb where datetime between '2006-03-01' and subdate(left(now(),10),interval 1 day);
呵呵,谢谢xqyuan每小时的是不是这样的select hour(datetime) as riqi,sum(number) as dianji from tb where date_format(created,'YYYY-MM-DD')= '2006-03-31' group by hour(datetime);但是不出来东西。。郁闷
select hour(datetime) as riqi,sum(number) as dianji from tb where date_format(datetime,'YYYY-MM-DD')= '2006-03-31' group by hour(datetime); 是这个,谢谢。
或
select count(*) from tb where datetime between '2006-03-01' and adddate('2006-03-01',interval 1 month);分钟小时天基本上就是这个样子了,
是这个,谢谢。