直接上图 原数据表 :ms_article sql查询语句
SELECT year(FROM_UNIXTIME(create_date/1000)) as year,month(FROM_UNIXTIME(create_date/1000)) as month,count(*) as count
from ms_article
GROUP BY year,month;
结果
Tips:因为create_date太大了无法转换所以需要/1000
直接上图 原数据表 :ms_article sql查询语句
SELECT year(FROM_UNIXTIME(create_date/1000)) as year,month(FROM_UNIXTIME(create_date/1000)) as month,count(*) as count
from ms_article
GROUP BY year,month;
结果
Tips:因为create_date太大了无法转换所以需要/1000