ENH: full SQL support for datetime64 values · Issue #7103 · pandas-dev/pandas (original) (raw)

In [65]: import pymysql
In [66]: engine_mysql = sqlalchemy.create_engine('mysql+pymysql://root@localhost/pandas_nosetest')
In [67]: df = pd.DataFrame({'A': pd.date_range('2013-01-01 09:00:00', periods=3),
...:                    'B': np.arange(3.0)})
In [68]: df.to_sql('test_datetime', engine_mysql, if_exists='replace')
Traceback (most recent call last):
File "<ipython-input-68-95961c7ce232>", line 1, in <module>
df.to_sql('test_datetime', engine_mysql, if_exists='replace')
...
File "C:\Anaconda\envs\devel\lib\site-packages\pymysql\converters.py", line 24, in escape_item
encoder = encoders[type(val)]
KeyError: <class 'pandas.tslib.Timestamp'>