datetime.sgml

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

        <entry>EAT</entry>
        <entry>+03:00</entry>
        <entry>Antananarivo, Comoro Time</entry>
       </row>
       <row>
        <entry>BT</entry>
        <entry>+03:00</entry>
        <entry>Baghdad Time</entry>
       </row>
       <row>
        <entry>EETDST</entry>
        <entry>+03:00</entry>
        <entry>Eastern Europe Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>HMT</entry>
        <entry>+03:00</entry>
        <entry>Hellas Mediterranean Time (?)</entry>
       </row>
       <row>
        <entry>BDST</entry>
        <entry>+02:00</entry>
        <entry>British Double Summer Time</entry>
       </row>
       <row>
        <entry>CEST</entry>
        <entry>+02:00</entry>
        <entry>Central European Summer Time</entry>
       </row>
       <row>
        <entry>CETDST</entry>
        <entry>+02:00</entry>
        <entry>Central European Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>EET</entry>
        <entry>+02:00</entry>
        <entry>Eastern European Time, Russia zone 1</entry>
       </row>
       <row>
        <entry>FWT</entry>
        <entry>+02:00</entry>
        <entry>French Winter Time</entry>
       </row>
       <row>
        <entry>IST</entry>
        <entry>+02:00</entry>
        <entry>Israel Standard Time</entry>
       </row>
       <row>
        <entry>MEST</entry>
        <entry>+02:00</entry>
        <entry>Middle European Summer Time</entry>
       </row>
       <row>
        <entry>METDST</entry>
        <entry>+02:00</entry>
        <entry>Middle Europe Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>SST</entry>
        <entry>+02:00</entry>
        <entry>Swedish Summer Time</entry>
       </row>
       <row>
        <entry>BST</entry>
        <entry>+01:00</entry>
        <entry>British Summer Time</entry>
       </row>
       <row>
        <entry>CET</entry>
        <entry>+01:00</entry>
        <entry>Central European Time</entry>
       </row>
       <row>
        <entry>DNT</entry>
        <entry>+01:00</entry>
        <entry><foreignphrase>Dansk Normal Tid</foreignphrase></entry>
       </row>
       <row>
        <entry>FST</entry>
        <entry>+01:00</entry>
        <entry>French Summer Time</entry>
       </row>
       <row>
        <entry>MET</entry>
        <entry>+01:00</entry>
        <entry>Middle European Time</entry>
       </row>
       <row>
        <entry>MEWT</entry>
        <entry>+01:00</entry>
        <entry>Middle European Winter Time</entry>
       </row>
       <row>
        <entry>MEZ</entry>
        <entry>+01:00</entry>
        <entry><foreignphrase>Mitteleurop鋓sche Zeit</></entry>
       </row>
       <row>
        <entry>NOR</entry>
        <entry>+01:00</entry>
        <entry>Norway Standard Time</entry>
       </row>
       <row>
        <entry>SET</entry>
        <entry>+01:00</entry>
        <entry>Seychelles Time</entry>
       </row>
       <row>
        <entry>SWT</entry>
        <entry>+01:00</entry>
        <entry>Swedish Winter Time</entry>
       </row>
       <row>
        <entry>WETDST</entry>
        <entry>+01:00</entry>
        <entry>Western European Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>GMT</entry>
        <entry>00:00</entry>
        <entry>Greenwich Mean Time</entry>
       </row>
       <row>
        <entry>UT</entry>
        <entry>00:00</entry>
        <entry>Universal Time</entry>
       </row>
       <row>
        <entry>UTC</entry>
        <entry>00:00</entry>
        <entry>Universal Coordinated Time</entry>
       </row>
       <row>
        <entry>Z</entry>
        <entry>00:00</entry>
        <entry>Same as UTC</entry>
       </row>
       <row>
        <entry>ZULU</entry>
        <entry>00:00</entry>
        <entry>Same as UTC</entry>
       </row>
       <row>
        <entry>WET</entry>
        <entry>00:00</entry>
        <entry>Western European Time</entry>
       </row>
       <row>
        <entry>WAT</entry>
        <entry>-01:00</entry>
        <entry>West Africa Time</entry>
       </row>
       <row>
        <entry>FNST</entry>
        <entry>-01:00</entry>
        <entry>Fernando de Noronha Summer Time</entry>
       </row>
       <row>
        <entry>FNT</entry>
        <entry>-02:00</entry>
        <entry>Fernando de Noronha Time</entry>
       </row>
       <row>
        <entry>BRST</entry>
        <entry>-02:00</entry>
        <entry>Brasilia Summer Time</entry>
       </row>
       <row>
        <entry>NDT</entry>
        <entry>-02:30</entry>
        <entry>Newfoundland Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>ADT</entry>
        <entry>-03:00</entry>
        <entry>Atlantic Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>AWT</entry>
        <entry>-03:00</entry>
        <entry>(unknown)</entry>
       </row>
       <row>
        <entry>BRT</entry>
        <entry>-03:00</entry>
        <entry>Brasilia Time</entry>
       </row>
       <row>
        <entry>NFT</entry>
        <entry>-03:30</entry>
        <entry>Newfoundland Standard Time</entry>
       </row>
       <row>
        <entry>NST</entry>
        <entry>-03:30</entry>
        <entry>Newfoundland Standard Time</entry>
       </row>
       <row>
        <entry>AST</entry>
        <entry>-04:00</entry>
        <entry>Atlantic Standard Time (Canada)</entry>
       </row>
       <row>
        <entry>ACST</entry>
        <entry>-04:00</entry>
        <entry>Atlantic/Porto Acre Summer Time</entry>
       </row>
       <row>
        <entry>EDT</entry>
        <entry>-04:00</entry>
        <entry>Eastern Daylight-Saving Time</entry>
       </row>
       <!--
      <row>
      <entry>ZP4</entry>
      <entry>-04:00</entry>
      <entry>GMT +4 hours</entry>
      </row>
       -->
       <row>
        <entry>ACT</entry>
        <entry>-05:00</entry>
        <entry>Atlantic/Porto Acre Standard Time</entry>
       </row>
       <row>
        <entry>CDT</entry>
        <entry>-05:00</entry>
        <entry>Central Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>EST</entry>
        <entry>-05:00</entry>
        <entry>Eastern Standard Time</entry>
       </row>
       <!--
      <row>
      <entry>ZP5</entry>
      <entry>-05:00</entry>
      <entry>GMT +5  hours</entry>
      </row>
       -->
       <row>
        <entry>CST</entry>
        <entry>-06:00</entry>
        <entry>Central Standard Time</entry>
       </row>
       <row>
        <entry>MDT</entry>
        <entry>-06:00</entry>
        <entry>Mountain Daylight-Saving Time</entry>
       </row>
       <!--
      <row>
      <entry>ZP6</entry>
      <entry>-06:00</entry>
      <entry>GMT +6  hours</entry>
      </row>
       -->
       <row>
        <entry>MST</entry>
        <entry>-07:00</entry>
        <entry>Mountain Standard Time</entry>
       </row>
       <row>
        <entry>PDT</entry>
        <entry>-07:00</entry>
        <entry>Pacific Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>AKDT</entry>
        <entry>-08:00</entry>
        <entry>Alaska Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>PST</entry>
        <entry>-08:00</entry>
        <entry>Pacific Standard Time</entry>
       </row>
       <row>
        <entry>YDT</entry>
        <entry>-08:00</entry>
        <entry>Yukon Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>AKST</entry>
        <entry>-09:00</entry>
        <entry>Alaska Standard Time</entry>
       </row>
       <row>
        <entry>HDT</entry>
        <entry>-09:00</entry>
        <entry>Hawaii/Alaska Daylight-Saving Time</entry>
       </row>
       <row>
        <entry>YST</entry>
        <entry>-09:00</entry>
        <entry>Yukon Standard Time</entry>
       </row>
       <row>
        <entry>MART</entry>
        <entry>-09:30</entry>
        <entry>Marquesas Time</entry>
       </row>
       <row>
        <entry>AHST</entry>
        <entry>-10:00</entry>
        <entry>Alaska/Hawaii Standard Time</entry>
       </row>
       <row>
        <entry>HST</entry>
        <entry>-10:00</entry>
        <entry>Hawaii Standard Time</entry>
       </row>
       <row>
        <entry>CAT</entry>
        <entry>-10:00</entry>
        <entry>Central Alaska Time</entry>
       </row>
       <row>
        <entry>NT</entry>
        <entry>-11:00</entry>
        <entry>Nome Time</entry>
       </row>
       <row>
        <entry>IDLW</entry>
        <entry>-12:00</entry>
        <entry>International Date Line, West</entry>
       </row>
      </tbody>
     </tgroup>
    </table>

  <formalpara>
   <title>Australian Time Zones</title>

   <para>
    There are three naming conflicts between Australian time zone
    names and time zone names commonly used in North and South America:
    <literal>ACST</literal>, <literal>CST</literal>, and
    <literal>EST</literal>.  If the run-time option
    <varname>australian_timezones</varname> is set to true then
    <literal>ACST</literal>, <literal>CST</literal>,
    <literal>EST</literal>, and <literal>SAT</literal> are interpreted
    as Australian time zone names, as shown in <xref
    linkend="datetime-oztz-table">. If it is false (which is the
    default), then <literal>ACST</literal>, <literal>CST</literal>,
    and <literal>EST</literal> are taken as American time zone names,
    and <literal>SAT</literal> is interpreted as a noise word
    indicating Saturday.
   </para>
  </formalpara>

    <table id="datetime-oztz-table">
     <title>Australian Time Zone Abbreviations for Input</title>
     <tgroup cols="3">
      <thead>
       <row>
        <entry>Time Zone</entry>
        <entry>Offset from UTC</entry>
        <entry>Description</entry>
       </row>
      </thead>
      <tbody>
       <row>
        <entry>ACST</entry>
        <entry>+09:30</entry>
        <entry>Central Australia Standard Time</entry>
       </row>
       <row>
        <entry>CST</entry>
        <entry>+10:30</entry>
        <entry>Australian Central Standard Time</entry>
       </row>
       <row>
        <entry>EST</entry>
        <entry>+10:00</entry>
        <entry>Australian Eastern Standard Time</entry>
       </row>
       <row>
        <entry>SAT</entry>
        <entry>+09:30</entry>
        <entry>South Australian Standard Time</entry>
       </row>
      </tbody>
     </tgroup>
    </table>

   <indexterm>
    <primary>time zone</primary>
    <secondary>configuration names</secondary>
   </indexterm>

   <para>
    <xref linkend="datetime-timezone-set-table"> shows the time zone
    names recognized by <productname>PostgreSQL</productname> as valid
    settings for the <xref linkend="guc-timezone"> parameter.  Note that
    these names are conceptually as well as practically different from
    the names shown in <xref linkend="datetime-timezone-input-table">:
    most of these names imply a local daylight-savings time rule, whereas
    the former names each represent just a fixed offset from UTC.
   </para>

   <para>
    In many cases there are several equivalent names for the same zone.
    These are listed on the same line.  The table is primarily sorted
    by the name of the principal city of the zone.
   </para>

    <table id="datetime-timezone-set-table">
     <title>Time Zone Names for Setting <varname>timezone</></title>
     <tgroup cols="1">
      <thead>
       <row>
        <entry>Time Zone</entry>
       </row>
      </thead>
<tbody>
 <row>
  <entry>Africa/Abidjan</entry>
 </row>
 <row>
  <entry>Africa/Accra</entry>
 </row>
 <row>
  <entry>Africa/Addis_Ababa</entry>
 </row>
 <row>
  <entry>Africa/Algiers</entry>
 </row>
 <row>
  <entry>Africa/Asmera</entry>
 </row>
 <row>
  <entry>Africa/Bamako</entry>
 </row>
 <row>
  <entry>Africa/Bangui</entry>
 </row>
 <row>
  <entry>Africa/Banjul</entry>
 </row>
 <row>
  <entry>Africa/Bissau</entry>
 </row>
 <row>
  <entry>Africa/Blantyre</entry>
 </row>
 <row>
  <entry>Africa/Brazzaville</entry>
 </row>
 <row>
  <entry>Africa/Bujumbura</entry>
 </row>
 <row>
  <entry>Africa/Cairo Egypt</entry>
 </row>
 <row>
  <entry>Africa/Casablanca</entry>
 </row>
 <row>
  <entry>Africa/Ceuta</entry>
 </row>
 <row>
  <entry>Africa/Conakry</entry>
 </row>
 <row>
  <entry>Africa/Dakar</entry>
 </row>
 <row>
  <entry>Africa/Dar_es_Salaam</entry>
 </row>
 <row>
  <entry>Africa/Djibouti</entry>
 </row>
 <row>
  <entry>Africa/Douala</entry>
 </row>
 <row>
  <entry>Africa/El_Aaiun</entry>
 </row>
 <row>
  <entry>Africa/Freetown</entry>
 </row>
 <row>
  <entry>Africa/Gaborone</entry>
 </row>
 <row>
  <entry>Africa/Harare</entry>
 </row>
 <row>
  <entry>Africa/Johannesburg</entry>
 </row>
 <row>
  <entry>Africa/Kampala</entry>
 </row>
 <row>
  <entry>Africa/Khartoum</entry>
 </row>
 <row>
  <entry>Africa/Kigali</entry>
 </row>
 <row>
  <entry>Africa/Kinshasa</entry>
 </row>
 <row>
  <entry>Africa/Lagos</entry>
 </row>
 <row>
  <entry>Africa/Libreville</entry>
 </row>
 <row>
  <entry>Africa/Lome</entry>
 </row>
 <row>
  <entry>Africa/Luanda</entry>
 </row>
 <row>
  <entry>Africa/Lubumbashi</entry>
 </row>
 <row>
  <entry>Africa/Lusaka</entry>
 </row>
 <row>
  <entry>Africa/Malabo</entry>
 </row>
 <row>
  <entry>Africa/Maputo</entry>
 </row>
 <row>
  <entry>Africa/Maseru</entry>
 </row>
 <row>
  <entry>Africa/Mbabane</entry>
 </row>
 <row>
  <entry>Africa/Mogadishu</entry>
 </row>
 <row>
  <entry>Africa/Monrovia</entry>
 </row>
 <row>
  <entry>Africa/Nairobi</entry>
 </row>
 <row>
  <entry>Africa/Ndjamena</entry>
 </row>
 <row>
  <entry>Africa/Niamey</entry>
 </row>
 <row>
  <entry>Africa/Nouakchott</entry>
 </row>
 <row>
  <entry>Africa/Ouagadougou</entry>
 </row>
 <row>
  <entry>Africa/Porto-Novo</entry>
 </row>
 <row>
  <entry>Africa/Sao_Tome</entry>
 </row>
 <row>
  <entry>Africa/Timbuktu</entry>
 </row>
 <row>
  <entry>Africa/Tripoli Libya</entry>
 </row>
 <row>
  <entry>Africa/Tunis</entry>
 </row>
 <row>
  <entry>Africa/Windhoek</entry>
 </row>
 <row>
  <entry>America/Adak America/Atka US/Aleutian</entry>
 </row>
 <row>
  <entry>America/Anchorage SystemV/YST9YDT US/Alaska</entry>
 </row>
 <row>
  <entry>America/Anguilla</entry>
 </row>
 <row>
  <entry>America/Antigua</entry>
 </row>
 <row>
  <entry>America/Araguaina</entry>
 </row>
 <row>
  <entry>America/Aruba</entry>
 </row>
 <row>
  <entry>America/Asuncion</entry>