Inserting a Python datetime.datetime object into MySQL

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

[asari3]

結果セットには datetime オブジェクトが返ってくるのにパラメータで使うにはこちらの責任で文字列に変換しなければならない？　ほんと？？