Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Well, clear enough I am not putting the right content inside, so I wonder if there is any converter in Mysql or you know something in Python that will work this out for me.
I guess formating the whole string will be a bit of a pain and "useless" if there is something like that already.

Can you try if it works when overriding the data type of the reflected column to be a string instead? I know it isn't optimal but perhaps you can live with it. The script might very well barf when doing that. Anyway, from the mysql prompt the date time string '2012-08-07T09:00:00' will be inserted properly. To override the reflected column: docs.sqlalchemy.org/en/rel_0_7/core/…
–
JohnPAug 7 '12 at 9:55

I think this would be a "bit" of a big hack for a datetime only. I fixed it already anyway, thanks. I also posted the solution under.
–
EphexeveAug 7 '12 at 19:12