2018-09-10 mysql
2018-09-10 本文已影响0人
土豆丝炒洋芋丝
# 每个小时
-- 1526572800 2018-05-18 00:00:00
-- 1526659199 2018-05-18 23:59:59
SELECT
AVG(profits),
HOUR(FROM_UNIXTIME(follow_time))
FROM p_orders_flow
WHERE
follow_time BETWEEN 1526572800 AND 1526659199
GROUP BY HOUR(FROM_UNIXTIME(follow_time))
