Mysql 根据时间戳按年月日分组统计-白红宇

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

阅读量：5096 次

发布时间：2019-06-13

本文共 644 字，大约阅读时间需要 2 分钟。

create_time时间格式

SELECT DATE_FORMAT(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks;        SELECT DATE_FORMAT(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;         SELECT DATE_FORMAT(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months

create_time时间戳格式

SELECT FROM_UNIXTIME(create_time,'%Y%u') weeks,COUNT(id) COUNT FROM role GROUP BY weeks;         SELECT FROM_UNIXTIME(create_time,'%Y%m%d') days,COUNT(id) COUNT FROM role GROUP BY days;         SELECT FROM_UNIXTIME(create_time,'%Y%m') months,COUNT(id) COUNT FROM role GROUP BY months

转载于:https://www.cnblogs.com/fps2tao/p/8989113.html

你可能感兴趣的文章