Mysql 根据时间月份进行分组

create_time时间格式

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

create_time时间戳格式

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