每两小时
SELECT
ROUND(avg( cod ),2) cod,
ROUND(avg(a.tds),2) tds,
ROUND(avg(a.turbidity),2) tur,
hTime
FROM
(
SELECT
cod,
tds,
turbidity,
DATE_FORMAT( concat( date( create_time ), ' ', floor( HOUR ( create_time ) / 2 ) * 2 ), '%H' ) AS hTime
FROM
dc_water_quality
WHERE
create_time >= '2020-06-26 00:00:00'
AND create_time <= '2020-06-26 23:59:59'
) a
GROUP BY
hTime
每半小时
select avg(aa),addtime from (
select pm25 , DATE_FORMAT( concat(date(addtime),' ',hour(addtime),':',floor( minute(addtime)/30 )*30) ,'%Y-%m-%d %H:%i') as addtime from bb
where addtime >= '2019-9-20 06:00:00' and addtime <= '2019-9-20 12:00:00') a
group by DATE_FORMAT( addtime ,'%Y-%m-%d %H:%i');
原文地址:https://blog.csdn.net/zhangweiguangsunjiao/article/details/101204093