通过年、月、日、时、分、秒分组
DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s')
SELECT COUNT(*),DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s')
FROM T_BASE_TABLE WHERE CREATE_TIME > '2022-08-30'
GROUP BY DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s')
ORDER BY CREATE_TIME DESC;
每半个小时分组查询数据总量
select
concat(DATE_FORMAT(CREATE_TIME, '%Y-%m-%d %H'),':',if(DATE_FORMAT(CREATE_TIME, '%i') >= 30, '00', '30')) time,
count(1)
from T_BASE_TABLE
where CREATE_TIME > '2023-05-31 00:00:00' and CREATE_TIME < '2023-05-31 23:59:59' group by time;