@@ -1932,19 +1932,27 @@ MINUTE TO SECOND
1932
1932
</row>
1933
1933
<row>
1934
1934
<entry><literal>04:05:06.789-8</literal></entry>
1935
- <entry>ISO 8601</entry>
1935
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1936
1936
</row>
1937
1937
<row>
1938
1938
<entry><literal>04:05:06-08:00</literal></entry>
1939
- <entry>ISO 8601</entry>
1939
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1940
1940
</row>
1941
1941
<row>
1942
1942
<entry><literal>04:05-08:00</literal></entry>
1943
- <entry>ISO 8601</entry>
1943
+ <entry>ISO 8601, with time zone as UTC offset </entry>
1944
1944
</row>
1945
1945
<row>
1946
1946
<entry><literal>040506-08</literal></entry>
1947
- <entry>ISO 8601</entry>
1947
+ <entry>ISO 8601, with time zone as UTC offset</entry>
1948
+ </row>
1949
+ <row>
1950
+ <entry><literal>040506+0730</literal></entry>
1951
+ <entry>ISO 8601, with fractional-hour time zone as UTC offset</entry>
1952
+ </row>
1953
+ <row>
1954
+ <entry><literal>040506+07:30:00</literal></entry>
1955
+ <entry>UTC offset specified to seconds (not allowed in ISO 8601)</entry>
1948
1956
</row>
1949
1957
<row>
1950
1958
<entry><literal>04:05:06 PST</literal></entry>
@@ -1980,25 +1988,29 @@ MINUTE TO SECOND
1980
1988
<entry><literal>PST8PDT</literal></entry>
1981
1989
<entry>POSIX-style time zone specification</entry>
1982
1990
</row>
1991
+ <row>
1992
+ <entry><literal>-8:00:00</literal></entry>
1993
+ <entry>UTC offset for PST</entry>
1994
+ </row>
1983
1995
<row>
1984
1996
<entry><literal>-8:00</literal></entry>
1985
- <entry>ISO-8601 offset for PST</entry>
1997
+ <entry>UTC offset for PST (ISO 8601 extended format) </entry>
1986
1998
</row>
1987
1999
<row>
1988
2000
<entry><literal>-800</literal></entry>
1989
- <entry>ISO-8601 offset for PST</entry>
2001
+ <entry>UTC offset for PST (ISO 8601 basic format) </entry>
1990
2002
</row>
1991
2003
<row>
1992
2004
<entry><literal>-8</literal></entry>
1993
- <entry>ISO-8601 offset for PST</entry>
2005
+ <entry>UTC offset for PST (ISO 8601 basic format) </entry>
1994
2006
</row>
1995
2007
<row>
1996
2008
<entry><literal>zulu</literal></entry>
1997
2009
<entry>Military abbreviation for UTC</entry>
1998
2010
</row>
1999
2011
<row>
2000
2012
<entry><literal>z</literal></entry>
2001
- <entry>Short form of <literal>zulu</literal></entry>
2013
+ <entry>Short form of <literal>zulu</literal> (also in ISO 8601) </entry>
2002
2014
</row>
2003
2015
</tbody>
2004
2016
</tgroup>
@@ -2336,6 +2348,24 @@ January 8 04:05:06 1999 PST
2336
2348
</tgroup>
2337
2349
</table>
2338
2350
2351
+ <para>
2352
+ In the <acronym>ISO</acronym> style, the time zone is always shown as
2353
+ a signed numeric offset from UTC, with positive sign used for zones
2354
+ east of Greenwich. The offset will be shown
2355
+ as <replaceable>hh</replaceable> (hours only) if it is an integral
2356
+ number of hours, else
2357
+ as <replaceable>hh</replaceable>:<replaceable>mm</replaceable> if it
2358
+ is an integral number of minutes, else as
2359
+ <replaceable>hh</replaceable>:<replaceable>mm</replaceable>:<replaceable>ss</replaceable>.
2360
+ (The third case is not possible with any modern time zone standard,
2361
+ but it can appear when working with timestamps that predate the
2362
+ adoption of standardized time zones.)
2363
+ In the other date styles, the time zone is shown as an alphabetic
2364
+ abbreviation if one is in common use in the current zone. Otherwise
2365
+ it appears as a signed numeric offset in ISO 8601 basic format
2366
+ (<replaceable>hh</replaceable> or <replaceable>hhmm</replaceable>).
2367
+ </para>
2368
+
2339
2369
<para>
2340
2370
The date/time style can be selected by the user using the
2341
2371
<command>SET datestyle</command> command, the <xref
0 commit comments