python mysql unsupported format character '''

Question

I'm getting an error replacing the %s to a date string.

import datetime

now = datetime.datetime.now()

day_minus_one = now + datetime.timedelta(days=-1)
new_date = day_minus_one.strftime('%Y%m%d')

db = MySQLdb.connect(host='127.0.0.1', user='root', passwd='', db='daily_report')
cur = db.cursor()

sql = "select date, stp_dpc, count(*), concat(round(avg(status = 'Success') * 100), '%') as Success from daily where status not in ('data1', 'data2', 'data3') and date = %s group by date, stp_dpc"

cur.execute(sql, new_date)
rows = cur.fetchall()

If i replace the equals to a literal string = '20170327' it does work perfectly.

cur.execute("select date, stp_dpc, count(*), concat(round(avg(status = 'Success') * 100), '%') as Success from daily where status not in ('data1', 'data2', 'data3') and date = '20170310' group by date, stp_dpc")
rows = cur.fetchall()

Is this a similar problem? I think you need to use strftime to coerce the value into the right format. ISO 8601 is preferred: YYYY-MM-DD. — tadman
– tadman, Commented Mar 28, 2017 at 23:50

Mr Ed · Accepted Answer · 2017-03-29 05:44:23Z

-1

How about ...and date = '{}' group by date, stp_dpc".format(new_date)

answered Mar 29, 2017 at 5:44

Mr Ed

752 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

python mysql unsupported format character '''

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related