mysql按年，季度，月，周，时间统计数据

按年统计

 select DATE_FORMAT(stat_date,'%Y') years,sum(duration) dur from tf_stat_vehicle_driving_data tv where 1=1 and 
 tv.ent_code=? GROUP BY years ORDER BY years desc

按季度统计

select concat(date_format(stat_date,'%Y'),
FLOOR((date_format(stat_date, '%m')+2)/3)) quarters,sum(duration) dur from tf_stat_vehicle_driving_data tv 
where 1=1 and tv.ent_code=? GROUP BY quarters ORDER BY quarters desc 

按月统计

select DATE_FORMAT(stat_date,'%Y%m') months,sum(duration) dur from tf_stat_vehicle_driving_data tv where 1=1 and 
tv.ent_code=? GROUP BY months ORDER BY months desc 

按周统计

 select DATE_FORMAT(stat_date,'%Y%u') weeks,sum(duration) dur from tf_stat_vehicle_driving_data tv where 1=1 and 
 tv.ent_code=? GROUP BY weeks ORDER BY weeks desc