[issue35145] sqlite3: "select *" should autoconvert datetime fields

Robert Pollak added the comment: Thank you, Paul, for your hints on sniffing. I have now asked at SqliteStudio for confirmation that they also do content sniffing to detect datetime text fields: https://github.com/pawelsalawa/sqlitestudio/issues/3449 . So in this issue I am suggesting to

[issue35145] sqlite3: "select *" should autoconvert datetime fields

Paul Ganssle added the comment: According to the sqlite documentation, there's no fundamental datetime type in sqlite: https://www.sqlite.org/datatype3.html#date_and_time_datatype SQLite does not have a storage class set aside for storing dates and/or times. Instead, the built-in

[issue35145] sqlite3: "select *" should autoconvert datetime fields

Change by Serhiy Storchaka : -- nosy: +berker.peksag, ghaering ___ Python tracker ___ ___ Python-bugs-list mailing list

[issue35145] sqlite3: "select *" should autoconvert datetime fields

Robert Pollak added the comment: (In fact, I am currently taking the first non-missing entry of each text column and trying to dateutil.parser.parse it. If that works, I use pandas.to_datetime on the column.) -- ___ Python tracker

[issue35145] sqlite3: "select *" should autoconvert datetime fields

New submission from Robert Pollak : Currently, fields are converted to datetime as described in https://docs.python.org/3/library/sqlite3.html#sqlite3.PARSE_COLNAMES : 'select x as "x [datetime]" from table' In my use case I don't know the names and locations of the datetime fields in