postgres.git / summary / log / commit / refs

commit    430f4497b02f3536b190cf5dca5da564eea151f4
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Sep 26 23:23:59 2023 +0000
First released in: 17.0, 11.22, 12.17, 13.13, 14.10, 15.5, 16.1

    doc:  clarify handling of time zones with "time with time zone"
    
    Reported-by: davecramer@postgres.rocks
    
    Discussion: https://postgr.es/m/168451942371.714.9173574930845904336@wrigleys.postgresql.org
    
    Backpatch-through: 11


doc/src/sgml/datatype.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 8d32a8c9c5b..5d237657059 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -2040,7 +2040,8 @@ MINUTE TO SECOND <literal>America/New_York</literal>. In this case specifying the date is required in order to determine whether standard or daylight-savings time applies. The appropriate time zone offset is recorded in the - <type>time with time zone</type> value. + <type>time with time zone</type> value and is output as stored; + it is not adjusted to the active time zone. </para> <table id="datatype-datetime-time-table"> [parent: 362b94d02aa5]