mysql 时间按季度分类_Mysql按小时，按日，按周，按月，按季度，按年分组统计数据...

按小时：sql

select from_unixtime(create_time,"%Y%m%d%H") as hours,count(id) as counts from table group by hours;函数

按日：spa

select from_unixtime(create_time,"%Y-%m-%d") as days,count(id) as counts from table group by days;unix

按周：code

select from_unixtime(create_time,"%Y-%u") as weeks,count(id) as counts from table group by weeks;orm

按月：字符串

select from_unixtime(create_time,"%Y-%m") as months,count(id) as counts from table group by months;table

按季度：form

select concat(from_unixtime(create_time,"%Y"),floor((from_unixtime(create_time,"%m")+2)/3)) as quarters,class

count(id) as counts from table group by quarters;

按年：

select from_unixtime(create_time,"%Y") as years,count(id) as counts from table group by years;

查询本年度数据：

select * fr