[issue45335] Default TIMESTAMP converter in sqlite3 ignores time zone

Erlend E. Aasland added the comment: Replacing the timestamp converter with datetime.datetime.fromisoformat sounds good to me. -- ___ Python tracker ___ _

[issue45335] Default TIMESTAMP converter in sqlite3 ignores time zone

Change by Florian Obersteiner : -- nosy: +MrFuppes ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https://ma

[issue45335] Default TIMESTAMP converter in sqlite3 ignores time zone

Change by Dong-hee Na : -- nosy: +corona10, erlendaasland ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: htt

[issue45335] Default TIMESTAMP converter in sqlite3 ignores time zone

Ian Fisher added the comment: Substitute "UTC offset" for "time zone" in my comment above. I have attached a minimal Python program demonstrating data loss from this bug. -- Added file: https://bugs.python.org/file50324/timestamp.py ___ Python trac

[issue45335] Default TIMESTAMP converter in sqlite3 ignores time zone

New submission from Ian Fisher : The SQLite converter that the sqlite3 library automatically registers for TIMESTAMP columns (https://github.com/python/cpython/blob/main/Lib/sqlite3/dbapi2.py#L66) ignores the time zone even if it is present and always returns a naive datetime object. I think