diff options
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 46 |
1 files changed, 38 insertions, 8 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 483263997f1..4512e80368f 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1977,19 +1977,27 @@ MINUTE TO SECOND </row> <row> <entry><literal>04:05:06.789-8</literal></entry> - <entry>ISO 8601</entry> + <entry>ISO 8601, with time zone as UTC offset</entry> </row> <row> <entry><literal>04:05:06-08:00</literal></entry> - <entry>ISO 8601</entry> + <entry>ISO 8601, with time zone as UTC offset</entry> </row> <row> <entry><literal>04:05-08:00</literal></entry> - <entry>ISO 8601</entry> + <entry>ISO 8601, with time zone as UTC offset</entry> </row> <row> <entry><literal>040506-08</literal></entry> - <entry>ISO 8601</entry> + <entry>ISO 8601, with time zone as UTC offset</entry> + </row> + <row> + <entry><literal>040506+0730</literal></entry> + <entry>ISO 8601, with fractional-hour time zone as UTC offset</entry> + </row> + <row> + <entry><literal>040506+07:30:00</literal></entry> + <entry>UTC offset specified to seconds (not allowed in ISO 8601)</entry> </row> <row> <entry><literal>04:05:06 PST</literal></entry> @@ -2026,16 +2034,20 @@ MINUTE TO SECOND <entry>POSIX-style time zone specification</entry> </row> <row> + <entry><literal>-8:00:00</literal></entry> + <entry>UTC offset for PST</entry> + </row> + <row> <entry><literal>-8:00</literal></entry> - <entry>ISO-8601 offset for PST</entry> + <entry>UTC offset for PST (ISO 8601 extended format)</entry> </row> <row> <entry><literal>-800</literal></entry> - <entry>ISO-8601 offset for PST</entry> + <entry>UTC offset for PST (ISO 8601 basic format)</entry> </row> <row> <entry><literal>-8</literal></entry> - <entry>ISO-8601 offset for PST</entry> + <entry>UTC offset for PST (ISO 8601 basic format)</entry> </row> <row> <entry><literal>zulu</literal></entry> @@ -2043,7 +2055,7 @@ MINUTE TO SECOND </row> <row> <entry><literal>z</literal></entry> - <entry>Short form of <literal>zulu</literal></entry> + <entry>Short form of <literal>zulu</literal> (also in ISO 8601)</entry> </row> </tbody> </tgroup> @@ -2394,6 +2406,24 @@ TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02' </table> <para> + In the <acronym>ISO</acronym> style, the time zone is always shown as + a signed numeric offset from UTC, with positive sign used for zones + east of Greenwich. The offset will be shown + as <replaceable>hh</replaceable> (hours only) if it is an integral + number of hours, else + as <replaceable>hh</replaceable>:<replaceable>mm</replaceable> if it + is an integral number of minutes, else as + <replaceable>hh</replaceable>:<replaceable>mm</replaceable>:<replaceable>ss</replaceable>. + (The third case is not possible with any modern time zone standard, + but it can appear when working with timestamps that predate the + adoption of standardized time zones.) + In the other date styles, the time zone is shown as an alphabetic + abbreviation if one is in common use in the current zone. Otherwise + it appears as a signed numeric offset in ISO 8601 basic format + (<replaceable>hh</replaceable> or <replaceable>hhmm</replaceable>). + </para> + + <para> The date/time style can be selected by the user using the <command>SET datestyle</command> command, the <xref linkend="guc-datestyle"/> parameter in the |