Message330393
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" :-/ |
|
Date |
User |
Action |
Args |
2018-11-25 19:47:29 | jondo | set | recipients:
+ jondo, ghaering, berker.peksag, matrixise, p-ganssle |
2018-11-25 19:47:29 | jondo | set | messageid: <1543175249.38.0.788709270274.issue35145@psf.upfronthosting.co.za> |
2018-11-25 19:47:29 | jondo | link | issue35145 messages |
2018-11-25 19:47:29 | jondo | create | |
|