@@ -1950,19 +1950,27 @@ MINUTE TO SECOND
1950
1950
</row>
1951
1951
<row>
1952
1952
<entry><literal>04:05:06.789-8</literal></entry>
1953
- <entry>ISO 8601</entry>
1953
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1954
1954
</row>
1955
1955
<row>
1956
1956
<entry><literal>04:05:06-08:00</literal></entry>
1957
- <entry>ISO 8601</entry>
1957
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1958
1958
</row>
1959
1959
<row>
1960
1960
<entry><literal>04:05-08:00</literal></entry>
1961
- <entry>ISO 8601</entry>
1961
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1962
1962
</row>
1963
1963
<row>
1964
1964
<entry><literal>040506-08</literal></entry>
1965
- <entry>ISO 8601</entry>
1965
+ <entry>ISO 8601, with time zone as UTC offset</entry>
1966
+ </row>
1967
+ <row>
1968
+ <entry><literal>040506+0730</literal></entry>
1969
+ <entry>ISO 8601, with fractional-hour time zone as UTC offset</entry>
1970
+ </row>
1971
+ <row>
1972
+ <entry><literal>040506+07:30:00</literal></entry>
1973
+ <entry>UTC offset specified to seconds (not allowed in ISO 8601)</entry>
1966
1974
</row>
1967
1975
<row>
1968
1976
<entry><literal>04:05:06 PST</literal></entry>
@@ -1998,25 +2006,29 @@ MINUTE TO SECOND
1998
2006
<entry><literal>PST8PDT</literal></entry>
1999
2007
<entry>POSIX-style time zone specification</entry>
2000
2008
</row>
2009
+ <row>
2010
+ <entry><literal>-8:00:00</literal></entry>
2011
+ <entry>UTC offset for PST</entry>
2012
+ </row>
2001
2013
<row>
2002
2014
<entry><literal>-8:00</literal></entry>
2003
- <entry>ISO-8601 offset for PST</entry>
2015
+ <entry>UTC offset for PST (ISO 8601 extended format) </entry>
2004
2016
</row>
2005
2017
<row>
2006
2018
<entry><literal>-800</literal></entry>
2007
- <entry>ISO-8601 offset for PST</entry>
2019
+ <entry>UTC offset for PST (ISO 8601 basic format) </entry>
2008
2020
</row>
2009
2021
<row>
2010
2022
<entry><literal>-8</literal></entry>
2011
- <entry>ISO-8601 offset for PST</entry>
2023
+ <entry>UTC offset for PST (ISO 8601 basic format) </entry>
2012
2024
</row>
2013
2025
<row>
2014
2026
<entry><literal>zulu</literal></entry>
2015
2027
<entry>Military abbreviation for UTC</entry>
2016
2028
</row>
2017
2029
<row>
2018
2030
<entry><literal>z</literal></entry>
2019
- <entry>Short form of <literal>zulu</literal></entry>
2031
+ <entry>Short form of <literal>zulu</literal> (also in ISO 8601) </entry>
2020
2032
</row>
2021
2033
</tbody>
2022
2034
</tgroup>
@@ -2354,6 +2366,24 @@ January 8 04:05:06 1999 PST
2354
2366
</tgroup>
2355
2367
</table>
2356
2368
2369
+ <para>
2370
+ In the <acronym>ISO</acronym> style, the time zone is always shown as
2371
+ a signed numeric offset from UTC, with positive sign used for zones
2372
+ east of Greenwich. The offset will be shown
2373
+ as <replaceable>hh</replaceable> (hours only) if it is an integral
2374
+ number of hours, else
2375
+ as <replaceable>hh</replaceable>:<replaceable>mm</replaceable> if it
2376
+ is an integral number of minutes, else as
2377
+ <replaceable>hh</replaceable>:<replaceable>mm</replaceable>:<replaceable>ss</replaceable>.
2378
+ (The third case is not possible with any modern time zone standard,
2379
+ but it can appear when working with timestamps that predate the
2380
+ adoption of standardized time zones.)
2381
+ In the other date styles, the time zone is shown as an alphabetic
2382
+ abbreviation if one is in common use in the current zone. Otherwise
2383
+ it appears as a signed numeric offset in ISO 8601 basic format
2384
+ (<replaceable>hh</replaceable> or <replaceable>hhmm</replaceable>).
2385
+ </para>
2386
+
2357
2387
<para>
2358
2388
The date/time style can be selected by the user using the
2359
2389
<command>SET datestyle</command> command, the <xref
0 commit comments