python-mysql How do I insert the current datetime into a MySQL database using Python?

Using Python, you can insert the current datetime into a MySQL database by first creating a datetime object and then using the cursor.execute() method. The following example code block shows how to do this:

import mysql.connector
from datetime import datetime
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
mycursor = mydb.cursor()
sql = "INSERT INTO customers (name, address, date_time) VALUES (%s, %s, %s)"
val = ("John", "Highway 21", datetime.now())
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")

1 record inserted.