mysql截取年月日与指定日期范围比较

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()函数;