How to Properly Insert Python datetime.datetime Objects into MySQL?

Inserting a Python datetime.datetime Object into MySQL

Users often face challenges when attempting to insert datetime.datetime objects into MySQL databases. One common error encountered is a "TypeError: not all arguments converted during string formatting" when trying to utilize a placeholder (%s) in an execute statement.

The root of this issue lies in MySQL's specific data type requirements. To successfully insert a datetime.datetime object into a time column, it is essential to format the object in the correct MySQL timestamp format using the time.strftime function.

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

This line of code converts the datetime.datetime object into a string representing the date and time in the format 'YYYY-MM-DD HH:MM:SS'. You can then use this string as a parameter for the SQL query:

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

By formatting the datetime object using time.strftime and passing it as a string, MySQL can correctly interpret and store the date and time information.

The above is the detailed content of How to Properly Insert Python datetime.datetime Objects into MySQL?. For more information, please follow other related articles on the PHP Chinese website!