查询MySql一段天数中每天固定时间段的数据

SELECT
	CONCAT(FLOOR( DATE_FORMAT( create_time, '%H' ) / 3 ) * 3,'~',FLOOR( DATE_FORMAT( create_time, '%H' ) / 3 ) * 3 + 3 ) AS `name`,
	event_type_code as eventTypeCode,
	COUNT( id ) 
FROM
	event_basic_info 
GROUP BY
	name ,
	eventTypeCode
ORDER BY
	name,
	eventTypeCode

SELECT
	id,
	FROM_UNIXTIME( createtime, '%Y-%m-%d %H:%i:%s' ) mydate 
FROM
	xxxx 
WHERE
	createtime BETWEEN 1641225600 
	AND 1641484799 
	AND ( FROM_UNIXTIME( createtime, '%H:%i:%s' ) BETWEEN '08:05:00' AND '08:05:01' OR FROM_UNIXTIME( createtime, '%H:%i:%s' ) BETWEEN '14:05:00' AND '14:05:01' );