按时间对MySQL数据进行分类

DATE_FORMAT函数将日期时间字段格式化为小时

 

SELECT
DATE_FORMAT(Time,'%Y-%m-%d %H:00:00') as datetime, (MAX(`MainLine#APEleEnergyTotal`) - MIN(`MainLine#APEleEnergyTotal`)) as datavalue
from report_MainLine
WHERE time >='2023-01-0 00:00:00' and time <='2023-01-2 00:00:00'
GROUP BY datetime ;