select month(FROM_UNIXTIME(time)) from table_name group by month(FROM_UNIXTIME(time)) 1、按月分组：select month(FROM_UNIXTIME(time)) from table_name group by month(FROM_UNIXTIME(time))2、按
SELECT * FROM hygl_member m
WHERE 1=1
AND DATE_FORMAT(m.`BIRTHDAY_B`,"%m-%d")>=DATE_FORMAT("2014-01-13","%m-%d")
AND DATE_FORMAT(m.`BIRTHDAY_B`,"%m-%d")
create_time时间格式
SELECT DATE_FORMAT(create_time,"%Y%u") weeks FROM role GROUP BY weeks;
SELECT DATE_FORMAT(create_time,"%Y%m%d") days FROM role GROUP BY days;
SELECT DA
