简介

由于实际业务需要，需要统计一天中，每间隔30分钟的请求数据数量

实际SQL语句

SELECT CONCAT(YEAR(e.create_time),"年",MONTH(e.create_time),'月',DAY(e.create_time),'日',HOUR( e.create_time ),'时',(FLOOR( MINUTE ( e.create_time ) / 30 )*30),'分') AS '日期',
    COUNT( * ) AS '数量' 
FROM
    yt_verify_log e 
WHERE
    e.create_time BETWEEN '2022-02-21 00:00:00' 
    AND '2022-02-21 23:59:59' 
GROUP BY
    HOUR ( e.create_time ) ,
    FLOOR( MINUTE ( e.create_time ) / 30 )
ORDER BY
    HOUR ( e.create_time );