阅读背景:

TypeError:在使用%Y-%m时,没有足够的参数用于格式化字符串- Python SQL连接

来源:互联网 
with engine.connect() as con:

    rs = con.execute("""
                        SELECT  datediff(STR_TO_DATE(CONCAT(year,'-',month,'-',day), '%Y-%m-%d') , current_date()) 
                        from TABLE 
                        WHERE datediff(STR_TO_DATE(CONCAT(year,'-',month,'-',day), '%Y-%m-%d') , current_date()) < 900
                        group by STR_TO_DATE(CONCAT(year,'-',month,'-',day), '%Y-%m-%d');
                    """)
with engine.connect() as con:

    rs = con.exe



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: