python - Insert datetime.datetime object in MySQL -

i'm trying insert datettime object mysql

>>> t datetime.datetime(2013, 5, 21, 19, 33, 36, tzinfo=tzutc()) >>> cursor.execute('insert tweets(created_at) values ({created_at})'.format(created_at=t)) 

error i'm getting:

traceback (most recent call last):   file "<stdin>", line 1, in <module>   file "/usr/lib/python2.7/dist-packages/mysqldb/cursors.py", line 174, in execute     self.errorhandler(self, exc, value)   file "/usr/lib/python2.7/dist-packages/mysqldb/connections.py", line 36, in defaulterrorhandler     raise errorclass, errorvalue _mysql_exceptions.programmingerror: (1064, "you have error in sql syntax; check manual corresponds mysql server version right syntax use near '19:33:36+00:00)' @ line 1") >>>  

mysql:

mysql> describe mytable; +-------------+---------------------+------+-----+---------+-------+ | field       | type                | null | key | default | | +-------------+---------------------+------+-----+---------+-------+  | created_at  | datetime            | yes  |     | null    |       |  +-------------+---------------------+------+-----+---------+-------+ 

try insert space after table name , put text inside "", this:

cursor.execute('insert tweets (created_at) values ("{created_at}")'.format(created_at=t))