Python Datetime to Mysql Datetime

[xav.vijay]

okay.... I have been trying this stuff for a couple days and I think I have completely lost my way.

I am trying to read data from an excel and import it into a MySQL DB.
When I fetch the data from the cell, this is what I get..

>>> ir_task.Cells(r,3).Value
<PyTime:12/14/2011 1:08:30 AM>

Now i have to insert this data to MySql and that field is also datetime (MySql Datetime).
After some googling, i came to know that Mysql accepts datetime in '%Y-%m-%d %H:%M:%S' format.

So what basically I want is.... to conver the above time to '%Y-%m-%d %H:%M:%S' format and how the insert query would look like...

Any help would be greatly appriciated.

Regards

Antonio...