[issue35145] sqlite3: optionally autoconvert table_info's DATETIME fields

Robert Pollak added the comment: Sorry for not providing a pull request yet. By the way, the "DB Browser for SQLite" (https://sqlitebrowser.org/) also interprets DATETIME fields correctly. (Could someone please change the "Stage" of this issue to "needs patch"?) -- versions:

[issue35145] sqlite3: optionally autoconvert table_info's DATETIME fields

Stéphane Wirtel added the comment: Hi @jondo, Of course you can submit a PR and we can help you with a review if we have time because we are volunteers and it's in function of our free time. Have a nice day, -- ___ Python tracker

[issue35145] sqlite3: optionally autoconvert table_info's DATETIME fields

Robert Pollak 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[:,

[issue35145] sqlite3: optionally autoconvert table_info's DATETIME fields

Change by Robert Pollak : -- title: sqlite3: "select *" should optionally sniff and autoconvert TEXT datetime fields -> sqlite3: optionally autoconvert table_info's DATETIME fields ___ Python tracker