mysql 每隔若干分钟 分组统计

取余
minute(create_time)-minute(create_time)%10
10，20，30
 
 
select count(*), concat(date(pay_time), '-', hour(pay_time), '-', round(minute(pay_time)/10,0)*10) as data1
from trade
where
pay_time >= '2022-04-30 05:00:00' and pay_time <='2022-04-30 06:00:00' group by date(pay_time), hour(pay_time), round(minute(pay_time)/10,0)*10;
 
  date_format(concat(date(create_time), ' ', if(hour(create_time)<=9, CONCAT('0', hour(create_time)), hour(create_time)), ':', if(minute(create_time)-minute(create_time)%10<=9, CONCAT('0', minute(create_time)-minute(create_time)%10), minute(create_time)-minute(create_time)%10)) , '%Y-%m-%d %H:%i') minute
posted @ 2025-06-05 17:22  papering  阅读(12)  评论(0)    收藏  举报