热门 sql时间戳按月份聚合
时间:2019-4-9
分类:
热度:3019
create_time为时间格式(字段名create_time 根据自己表字段修改,数据库中存为201610071202)
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 ...