mysql date按小时分组

SELECT 
    DATE(timestamp) AS date,
    HOUR(timestamp) AS hour,
    COUNT(*) AS count
FROM 
    logs
GROUP BY 
    DATE(timestamp), 
    HOUR(timestamp)
ORDER BY 
    date, 
    hour;

SELECT 
    DATE(CONVERT(timestamp, DATETIME)) AS date,
    HOUR(CONVERT(timestamp, DATETIME)) AS hour,
    COUNT(*) AS count
FROM 
    logs
GROUP BY 
    DATE(CONVERT(timestamp, DATETIME)), 
    HOUR(CONVERT(timestamp, DATETIME))
ORDER BY 
    date, 
    hour;

SELECT 
    DATE(timestamp) AS date,
    HOUR(timestamp) AS hour,
    COUNT(*) AS count
FROM 
    logs
WHERE 
    timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY)
GROUP BY 
    DATE(timestamp), 
    HOUR(timestamp)
ORDER BY 
    date, 
    hour;