title: Inserting a Python datetime.datetime object into MySQL
body: <p>I have a date column in a MySQL table. I want to insert a <code>datetime.datetime()</code> object into this column. What should I be using in the execute statement?</p>
  
  <p>I have tried:</p>
  
  <pre><code>now = datetime.datetime(2009,5,5)
  
  cursor.execute("INSERT INTO table
  (name, id, datecolumn) VALUES (%s, %s
  , %s)",("name", 4,now))
  </code></pre>
  
  <p>I am getting an error as: <code>"TypeError: not all arguments converted during string formatting"</code>
  What should I use instead of <code>%s</code>?</p>