Inserting a Python datetime.datetime object into MySQL

python mysql datetime
Scaraffe picture Scaraffe · Jul 16, 2009 · Viewed 223.8k times · Source

I have a date column in a MySQL table. I want to insert a datetime.datetime() object into this column. What should I be using in the execute statement?

I have tried:

now = datetime.datetime(2009,5,5)

cursor.execute("INSERT INTO table
(name, id, datecolumn) VALUES (%s, %s
, %s)",("name", 4,now))

I am getting an error as: "TypeError: not all arguments converted during string formatting" What should I use instead of %s?

Answer

g33kz0r picture g33kz0r · Dec 22, 2010

For a time field, use:

import time    
time.strftime('%Y-%m-%d %H:%M:%S')

I think strftime also applies to datetime.

Related questions

DateTimeField received a naive datetime

I have model with DateTimeField column. I'm try to insert row with database current_time value directly into table by sql query. My sql query for MySQL database like: INSERT INTO MyTable (..., my_datetime, ...) VALUES (..., current_time, ...) And get: RuntimeWarning: …

Read More
SqlAlchemy mysql millisecond or microsecond precision

I've been venturing down the odyssey of trying to get fractional time resolution working properly in my database. I use the python method datetime.now() in order to create date objects. I then store these objects in a field which …

Read More
Installing specific package versions with pip

I'm trying to install version 1.2.2 of the MySQL_python adaptor, using a fresh virtualenv created with the --no-site-packages option. The current version shown in PyPi is 1.2.3. Is there a way to install the older version? I found an article stating …

Read More