From 359a2df63065e3327ca3ab7cb0cfb73da6934a31 Mon Sep 17 00:00:00 2001 From: Robert Treat Date: Mon, 3 Feb 2025 10:42:39 -0500 Subject: [PATCH v1] Clarify timestamptz input time zone behavior Content-Type: text/plain; charset="utf-8" --- doc/src/sgml/datatype.sgml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 1d9127e94e..ef5c90775a 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -2254,12 +2254,12 @@ TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02' - For timestamp with time zone, the internally stored - value is always in UTC (Universal - Coordinated Time, traditionally known as Greenwich Mean Time, - GMT). An input value that has an explicit - time zone specified is converted to UTC using the appropriate offset - for that time zone. If no time zone is stated in the input string, + For timestamp with time zone, an input value that has an + explicit time zone specified will be converted to + UTC (Universal Coordinated Time) using the appropriate offset for that + time zone. This value will be stored internally as UTC and the original + specified time zone is not retained. + If no time zone is stated in the input string, then it is assumed to be in the time zone indicated by the system's parameter, and is converted to UTC using the offset for the timezone zone. -- 2.24.3 (Apple Git-128)