其中 created_at 是时间戳,如果是时间格式那么无需 FROM_UNIXTIME 转换。

SELECT
    HOUR (FROM_UNIXTIME(created_at)) AS Hour,
    count(*) AS Count
FROM
    yun_user
WHERE
    FROM_UNIXTIME(created_at, '%Y-%m-%d') = '2018-01-03'
GROUP BY
    HOUR (FROM_UNIXTIME(created_at))
ORDER BY
    HOUR (FROM_UNIXTIME(created_at));
SELECT
    FROM_UNIXTIME(created_at,'%H') AS Hour,
    count(*) AS Count
FROM
    yun_user
WHERE
    FROM_UNIXTIME(created_at, '%Y-%m-%d') = '2018-01-03'
GROUP BY
    FROM_UNIXTIME(created_at,'%H')
ORDER BY
    FROM_UNIXTIME(created_at,'%H');
点赞 ({{click_count}}) 收藏 (0)