This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author jondo
Recipients berker.peksag, ghaering, jondo, matrixise, p-ganssle
Date 2018-11-25.19:47:29
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1543175249.38.0.788709270274.issue35145@psf.upfronthosting.co.za>
In-reply-to
Content
So my workaround is of course
```
table = pd.read_sql_query('select * from table', con)
column_type = pd.read_sql_query('PRAGMA table_info("table")', con)['type']
datetimes = table.columns[column_type == 'DATETIME']
table.loc[:, datetimes] = table.loc[:, datetimes].apply(pd.to_datetime)
```

I would be interested in creating a pull request for the `detect_types=CONVERT_DATETIME` argument that I described. Is there any chance to get that merged? I currently see 541 open cpython pull requests labeled "awaiting review" :-/
History
Date User Action Args
2018-11-25 19:47:29jondosetrecipients: + jondo, ghaering, berker.peksag, matrixise, p-ganssle
2018-11-25 19:47:29jondosetmessageid: <1543175249.38.0.788709270274.issue35145@psf.upfronthosting.co.za>
2018-11-25 19:47:29jondolinkissue35145 messages
2018-11-25 19:47:29jondocreate