flask_sqlalchemy生成的sql不对_编程技术网-程序员技术内容聚合平台

（在说正事之前，我要推荐一个福利：你还在原价购买阿里云、腾讯云、华为云服务器吗？那太亏啦！来这里，新购、升级、续费都打折，能够为您省60%的钱呢！2核4G企业级云服务器低至69元/年，点击进去看看吧>>>)

这是我的代码

today_user = db.session.execute("""select sum(money) from tb_recharge 
where state = 1 and date_format(create_time,'%Y') = '2021'""")

输出的结果

2021-03-25 15:54:31,726 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'sql_mode'
2021-03-25 15:54:31,727 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,732 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'lower_case_table_names'
2021-03-25 15:54:31,733 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,754 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()
2021-03-25 15:54:31,754 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,761 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8mb4' and `Collation` = 'utf8mb4_bin'
2021-03-25 15:54:31,761 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,769 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2021-03-25 15:54:31,769 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,777 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2021-03-25 15:54:31,777 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,783 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8mb4) COLLATE utf8mb4_bin AS anon_1
2021-03-25 15:54:31,783 INFO sqlalchemy.engine.base.Engine ()
2021-03-25 15:54:31,797 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2021-03-25 15:54:31,797 INFO sqlalchemy.engine.base.Engine select sum(money) from tb_recharge 
                    where state = 1 and date_format(create_time,'%%Y') = '2021'
2021-03-25 15:54:31,797 INFO sqlalchemy.engine.base.Engine ()

会多出来个%，很奇怪，试过了‘%%Y’,不行，
数据库版本是 mysql5.7.17

###

为何多个%，换个写法试试 create_time BETWEEN '2021-01-01 00:00:00' AND '2021-12-31 23:59:59' 或 Year(create_time) = 2021