Robert Pollak <[email protected]> added the comment:
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" :-/
----------
_______________________________________
Python tracker <[email protected]>
<https://bugs.python.org/issue35145>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe:
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
