bpo-45335: Add note to sqlite3 docs about "timestamp" converter (pythonGH-29200)

iafisher · miss-islington · commit b1b563b15243 · 2021-10-29T20:17:29.000Z
(cherry picked from commit 3877fc0) Co-authored-by: Ian Fisher <ian@iafisher.com>
diff --git 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:
 
