mysql按每小时、每半小时分组统计查询

按每小时：

SELECT sum(`diff`) as d,HOUR(updatetime) as t,sum(lag) as lags FROM kfk_monitor
WHERE topic='web' and (updatetime between '2021-01-25 00:00:00' and'2021-01-25 23:59:59')
GROUP BY t

 

---

按每半小时：

SELECT sum(`diff`) as d,DATE_FORMAT( concat(date(updatetime),' ',hour(updatetime),':',floor( minute(updatetime)/30 )*30) ,'%Y-%m-%d %H:%i')  as t,sum(lag) as lags from kfk_monitor 
WHERE topic='web' and (updatetime between '2021-01-25 00:00:00' and'2021-01-25 23:59:59')
group by DATE_FORMAT( t ,'%Y-%m-%d %H:%i');