diff options
Diffstat (limited to 'doc/src/sgml/datetime.sgml')
| -rw-r--r-- | doc/src/sgml/datetime.sgml | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/doc/src/sgml/datetime.sgml b/doc/src/sgml/datetime.sgml index 93315564c8..d1f82c9d6e 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.38 2003/11/29 19:51:36 pgsql Exp $ +$PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.39 2003/12/01 20:34:53 tgl Exp $ --> <appendix id="datetime-appendix"> @@ -370,9 +370,10 @@ $PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.38 2003/11/29 19:51:36 pgsql E <para> <xref linkend="datetime-timezone-table"> shows the time zone - abbreviations recognized by <productname>PostgreSQL</productname>. - <productname>PostgreSQL</productname> contains internal tabular - information for time zone decoding, since there is no standard + abbreviations recognized by <productname>PostgreSQL</productname> + in date/time input values. + <productname>PostgreSQL</productname> uses internal tables + for time zone input decoding, since there is no standard operating system interface to provide access to general, cross-time zone information. The underlying operating system <emphasis>is</emphasis> used to provide time zone information for @@ -380,6 +381,15 @@ $PostgreSQL: pgsql/doc/src/sgml/datetime.sgml,v 2.38 2003/11/29 19:51:36 pgsql E </para> <para> + Keep in mind also that the time zone names + recognized by <command>SET TIMEZONE</> are operating-system + dependent and may have little to do with <xref + linkend="datetime-timezone-table">. For example, some systems + recognize values like <literal>'Europe/Rome'</> in <command>SET + TIMEZONE</>. + </para> + + <para> The table is organized by time zone offset from <acronym>UTC</>, rather than alphabetically. This is intended to facilitate matching local usage with recognized abbreviations for cases where |