Robert Pollak <robert.pol...@posteo.net> added the comment:
I have created the attached sqlite database file (with SQLiteStudio) for testing. I contains a table `t` with a TEXT column `x` and a DATETIME (according to SQLiteStudio) column `y`. The table contains a single row with the value `2018-11-05 12:20:30` for both columns. For some reason SQLiteStudio manages to know these types (although the columns contain the same value, and even after renaming the file and reconnecting to it), so sqlite3 should also be able to detect them. ---------- Added file: https://bugs.python.org/file47905/SQLiteStudio-3449.sqlite _______________________________________ Python tracker <rep...@bugs.python.org> <https://bugs.python.org/issue35145> _______________________________________ _______________________________________________ Python-bugs-list mailing list Unsubscribe: https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com