将 Python datetime.datetime 对象插入 MySQL

2021-11-20 00:00:00 python datetime mysql

我在 MySQL 表中有一个日期列.我想在此列中插入一个 datetime.datetime() 对象.我应该在执行语句中使用什么?

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?

我试过了:

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

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

我收到如下错误:TypeError:并非所有参数都在字符串格式化期间转换"我应该用什么来代替 %s?

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

推荐答案

对于时间字段，使用:

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

我认为 strftime 也适用于 datetime.

I think strftime also applies to datetime.

相关文章