mysql 根据时间戳按年月日分组统计

2019独角兽企业重金招聘Python工程师标准>>>

#按月统计购买的人数(并且去掉重复的人数)
SELECT DATE_FORMAT(createday,'%Y%m') months,COUNT(DISTINCT uid) uids FROM principal
WHERE `type`=1 AND parentid IS NULL
GROUP BY months

#按周来统计
SELECT DATE_FORMAT(createday,'%Y%u') weeks,COUNT(DISTINCT uid) uids FROM principal
WHERE `type`=1
GROUP BY weeks;

#按照天来统计
SELECT DATE_FORMAT(createday,'%Y%m%d') days,COUNT(DISTINCT uid) uids  FROM principal
WHERE `type`=1
GROUP BY days;

转载于:https://my.oschina.net/u/1034176/blog/370162