TypeError: not all arguments converted during string formatting (Python insert datetime into postgres)

Question

I want to insert datetime into postgres via python

from datetime import datetime, timedelta
start_time_format = datetime.now() - timedelta(hours =33)
start_time =  start_time_format.strftime("%Y-%m-%d %H:%M")
conn = psycopg2.connect(...*connect postgresql*..)
cursor = conn.cursor()
cursor.execute("""INSERT INTO table01(start_time_str) VALUES(%s);""", (start_time))
conn.commit()

I get the following error:

cursor.execute("""INSERT INTO table01(start_time_str) VALUES(%s);""", (start_time))

TypeError: not all arguments converted during string formatting

I try to change other DataType(text、character、timestamp without time zone. ...) But still Error:(

The problem is that the second argument to execute() is supposed to be a tuple. And even though you have (start_time) in parentheses, that does not make it a tuple. You need (start_time,) to make it a tuple. — John Gordon
– John Gordon, Commented Jul 15, 2022 at 4:17
This (start_time) is not correct. If you want a single element tuple it needs to be (start_time,). Note the ','. — Adrian Klaver
– Adrian Klaver, Commented Jul 15, 2022 at 4:17

Shaukat · Accepted Answer · 2022-07-15 04:56:46Z

0

Rectifying my previous response after reading comments from @AdrianKlaver and @JohnGordon. There comments should be taken as the correct answer, I am just modifying my response so that future readers do the right thing

cursor.execute("""INSERT INTO table01(start_time_str) VALUES(%s);""", (start_time,))

As @AdrianKlaver and @JohnGordon mentioned, just watch out for the ',' in (start_time,) to pass it as a tuple to the cursor.execute()

edited Jul 15, 2022 at 4:56

answered Jul 15, 2022 at 3:30

Shaukat

913 bronze badges

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

2 Comments

John Gordon Over a year ago

No, this isn't the problem...

Shaukat Over a year ago

Thanks @JohnGordon and AdrianKlaver. . The tuple (value,) is a right way to do it.

Collectives™ on Stack Overflow

TypeError: not all arguments converted during string formatting (Python insert datetime into postgres)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related