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