如何用MySQL查询特定日期范围内的年月日数据？

本文共计58个文字，预计阅读时间需要1分钟。

sqlSELECT SUM(rise_number) AS numberFROM tab_rise_recordWHERE date_format(rise_time, '%Y-%m-%d') BETWEEN '2021-12-14' AND '2022-02-24'

selectsum(rise_number)asnumberfromtab_rise_recordwheredate_format(rise_time,%Y-%m-%d)betwe

select sum(rise_number) as number from tab_rise_record where date_format(rise_time ,'%Y-%m-%d' ) between '2021-12-14' and '2022-02-24'

使用:date_format()函数;