[Python-checkins] bpo-45335: Add note to `sqlite3` docs about "timestamp" converter (GH-29200) (GH-29319)
ambv
webhook-mailer at python.org
Fri Oct 29 16:41:54 EDT 2021
https://github.com/python/cpython/commit/8ea665c730cd86a321c558c012bef84f454efa4f
commit: 8ea665c730cd86a321c558c012bef84f454efa4f
branch: 3.10
author: Miss Islington (bot) <31488909+miss-islington at users.noreply.github.com>
committer: ambv <lukasz at langa.pl>
date: 2021-10-29T22:41:45+02:00
summary:
bpo-45335: Add note to `sqlite3` docs about "timestamp" converter (GH-29200) (GH-29319)
(cherry picked from commit 3877fc02f7a8801ba5ce0e94b6075b3fdd9778d0)
Co-authored-by: Ian Fisher <ian at iafisher.com>
files:
M Doc/library/sqlite3.rst
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst
index dc9aeb2ba3f59..16d2c2e85f42b 100644
--- a/Doc/library/sqlite3.rst
+++ b/Doc/library/sqlite3.rst
@@ -1072,6 +1072,12 @@ If a timestamp stored in SQLite has a fractional part longer than 6
numbers, its value will be truncated to microsecond precision by the
timestamp converter.
+.. note::
+
+ The default "timestamp" converter ignores UTC offsets in the database and
+ always returns a naive :class:`datetime.datetime` object. To preserve UTC
+ offsets in timestamps, either leave converters disabled, or register an
+ offset-aware converter with :func:`register_converter`.
.. _sqlite3-controlling-transactions:
More information about the Python-checkins
mailing list