转换 年 date_format(create_time, ‘%Y’)
转换 月 date_format(create_time, ‘%Y-%m’)
转换 日 date_format(create_time, ‘%Y-%m-%d’)
分组查询 group by
按照年分组查询
select date_format(create_time, '%Y') year, count(*) coun
from t_content
group by date_format(create_time, '%Y');
按照月分组查询
select date_format(create_time, '%Y-%m') mon, 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');