Mysq根据时间分组求和

------------------
SELECT sum(rate) , DATE_FORMAT(`cut_time`, '%Y-%m-%d') AS mth  FROM `user_circuit_info`  group by mth HAVING mth BETWEEN '2021-10-26' AND '2021-11-03'

------将时间戳的毫秒数转为 YYYY-dd-MM ---------
select FROM_UNIXTIME(`cut_time`, '%Y年 %c月份') AS mth from   `user_circuit_info` 
--------将字符串时间yyyy-mm-dd HH:mm:ss 转为yyyy-mm-dd---------
select DATE_FORMAT(`cut_time`, '%Y-%m-%d') AS mth from   `user_circuit_info`
``
运行结果


![在这里插入图片描述](https://img-blog.csdnimg.cn/070e727e319344ce96fd0060fc788947.png#pic_center)