flask_sqlalchemy生成的sql不正确

查询代码：

db.session.execute("""select sum(money) from tb_recharge 
                where state = 1 and date_format(create_time,'%Y') = '{}'""".format(year_time))

生成的sql：

select sum(money) from tb_recharge 
                    where state = 1 and date_format(create_time,'%%Y') = '2021'

会多生成一个百分号，求解答

改成如下试试：

db.session.execute("""select sum(money) from tb_recharge 
                where state = 1 and date_format(create_time,'%%Y') = '{}'""".format(year_time))