按月统计(一)
select date_format(create_time, '%Y-%m') mont, count(*) coun
from t_content
group by date_format(create_time, '%Y-%m');
按天统计(二)
select date_format(create_time, '%Y-%m-%d') dat, count(*) coun
from t_content
group by date_format(create_time, '%Y-%m-%d');
按天统计(三)
select from_unixtime(create_time / 1000, '%Y-%m-%d') dat, count(*) coun
from t_content
group by from_unixtime(create_time / 1000, '%Y-%m-%d')
其他
格式转换
select from_unixtime(create_time / 1000, '%Y-%m-%d %H:%i:%S') create_time
from t_content
原文链接:https://blog.csdn.net/lpw_cn/article/details/89487801
---更新
统计近3个月的数据
SELECT type_name,company,sum(num) as num,mont FROM asrs_wmscloud.v_selectByMonth
group by type_name,company,type_name,mont
having mont> DATE_FORMAT((CURDATE() - INTERVAL 2 MONTH), '%Y-%m')
;