//根据 一天中的 24 小时查询 ,
SELECT
FROM_UNIXTIME(record_time, '%H') time,
day_total_Energy
FROM
system
WHERE
record_time >= 1486915200
GROUP BY
FROM_UNIXTIME(record_time, '%Y-%m-%d %H')
// 根据 一月的天数分组查询
SELECT
FROM_UNIXTIME(record_time, '%d') time,
AVG(current_power) dayAvgPower
FROM
system
WHERE
record_time >= 1485878400
GROUP BY
FROM_UNIXTIME(record_time, '%Y-%m-%d')