按照创建时间统计表里不同时间段数据发生数量

例如统计每分钟上传文件的数量，按照年月日小时分钟进行分组

sql例子：

SELECT
  YEAR(creation_date) AS year,
  MONTH(creation_date) AS month,
    DATE_FORMAT(creation_date, '%Y-%m-%d') as tian,
   HOUR(creation_date) AS hour,
      DATE_FORMAT(creation_date, '%Y-%m-%d %H:%i') as date_minute,

  COUNT(*) AS data_count
FROM
  hfle_file
  WHERE `bucket_name` = 'candidate' 
GROUP BY
  YEAR(creation_date),
  MONTH(creation_date),
    tian,
 hour(creation_date),
 DATE_FORMAT(creation_date, '%Y-%m-%d %H:%i')
ORDER BY
  year,
  month,
    tian,
 hour,
 date_minute

结果示例：

 
 

例子2 根据某些条件查询。按天分组 统计每天产生的数据量

sql例子：

SELECT
DATE_FORMAT(creation_date, '%Y-%m-%d') as 日期,
 -- DAY(creation_date) AS 日期,
  COUNT(*) AS 数量 
FROM
 `hzero_message`.`hmsg_message` 
WHERE
 `message_type_code` = 'EMAIL' 
 AND `server_code` = 'BOOGOO_SYS' 
 AND `send_flag` = '1' 
 AND `creation_date` >= '2024-07-01 00:00:00' 
 AND `creation_date` <= '2025-08-31 23:59:59' 
 GROUP BY
  DATE_FORMAT(creation_date, '%Y-%m-%d')

结果示例：