1、按日期进行分组统计
# 按天进行统计
SELECT DATE_FORMAT( a.CreateTime, "%Y-%m-%d" ),COUNT(*),a.PlayerName,a.CreateTime FROM crazy_demigod.player a
WHERE a.AreaId=1001 AND a.CreateTime>='2012-1-1' AND a.CreateTime<='2013-2-1'
GROUP BY DATE_FORMAT( a.CreateTime, "%Y-%m-%d" )
查询某天:
deteline, "%Y-%m-%d
某时:
deteline, "%Y-%m-%d %H"