TypeError: not enough arguments for format string - Python SQL connection while using %Y-%m

Question

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');
                    """)

I feel the compiler is getting confused with '%Y-%m-%d', I might be wrong. Could someone help me on how to avoid this error:

Type Error:not enough arguments for format string

What are you using to connect to the mysql database? Which package? You might explain what you are trying to accomplish with your query. — wwii
– wwii, Commented Oct 18, 2016 at 20:50

alexbclay · Accepted Answer · 2016-10-18 20:55:23Z

22

It sees your % signs and thinks you want to format the string. I believe you should be able to replace them with %% to indicate that you want the character, not a format substitution.

answered Oct 18, 2016 at 20:55

alexbclay

1,42915 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bishwas Mishra Over a year ago

Awesome answer.

Eugene · Accepted Answer · 2016-10-18 20:56:01Z

4

You need to escape the %:

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');
                    """)

% is a reserved character in MySQL (wildcard).

answered Oct 18, 2016 at 20:56

Eugene

1,65915 silver badges21 bronze badges

Collectives™ on Stack Overflow

TypeError: not enough arguments for format string - Python SQL connection while using %Y-%m

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related