datetime.sgml

关系型数据库 Postgresql 6.5.2

<!--
$Header: /usr/local/cvsroot/pgsql/doc/src/sgml/datetime.sgml,v 2.4 1999/06/23 06:17:51 thomas Exp $
Date/time details

$Log: datetime.sgml,v $
Revision 2.4  1999/06/23 06:17:51  thomas
Clarify input/output timezone information.
Add detail on exact interpretation of "concatenated date"
 for various lengths.

Revision 2.3  1999/05/26 17:30:28  thomas
Add chapters on CVS access, MVCC, SQL theory to the docs.
Add an appendix with more details on date/time attributes and handling.
Update most references to Postgres version numbers to 6.5,
 *except* for the porting list which will require a report
 from a successful installation to be updated.

Revision 2.2  1999/05/22 02:27:23  thomas
Finish initial markup of cvs.sgml, and include it in the programmer's guide
 and the integrated doc. Clean up other markup.

-->

<appendix label="UG1" id="datetime-appendix">
 <title id="datetime-appendix-title">Date/Time Support</title>

 <sect1>
  <title>Time Zones</title>

  <para>
   <productname>Postgres</productname> must have internal tabular
   information for time zone decoding, since there is no *nix standard
   system interface to provide access to general, cross-timezone
   information. The underlying OS <emphasis>is</emphasis> used to
   provide time zone information for <emphasis>output</emphasis>.

   <table tocentry="1">
    <title><productname>Postgres</productname> Recognized Time Zones</title>
    <titleabbrev>Time Zones</titleabbrev>
    <tgroup cols="3">
     <thead>
      <row>
       <entry>Time Zone</entry>
       <entry>Offset from UTC</entry>
       <entry>Description</entry>
      </row>
     </thead>
     <tbody>
      <row>
       <entry>NZDT</entry>
       <entry>+13:00</entry>
       <entry>New Zealand Daylight Time</entry>
      </row>
      <row>
       <entry>IDLE</entry>
       <entry>+12:00</entry>
       <entry>International Date Line, East</entry>
      </row>
      <row>
       <entry>NZST</entry>
       <entry>+12:00</entry>
       <entry>New Zealand Std Time</entry>
      </row>
      <row>
       <entry>NZT</entry>
       <entry>+12:00</entry>
       <entry>New Zealand Time</entry>
      </row>
      <row>
       <entry>AESST</entry>
       <entry>+11:00 </entry>
       <entry>Australia Eastern Summer Std Time</entry>
      </row>
      <row>
       <entry>ACSST</entry>
       <entry>+10:30 </entry>
       <entry>Central Australia Summer Std Time</entry>
      </row>
      <row>
       <entry>CADT</entry>
       <entry>+10:30 </entry>
       <entry>Central Australia Daylight Savings Time</entry>
      </row>
      <row>
       <entry>SADT</entry>
       <entry>+10:30</entry>
       <entry>South Australian Daylight Time</entry>
      </row>
      <row>
       <entry>AEST</entry>
       <entry>+10:00 </entry>
       <entry>Australia Eastern Std Time</entry>
      </row>
      <row>
       <entry>EAST</entry>
       <entry>+10:00 </entry>
       <entry>East Australian Std Time</entry>
	</row>
      <row>
       <entry>GST</entry>
       <entry>+10:00</entry>
       <entry>Guam Std Time, USSR Zone 9</entry>
      </row>
      <row>
       <entry>LIGT</entry>
       <entry>+10:00</entry>
       <entry>Melbourne, Australia</entry>
      </row>
      <row>
       <entry>ACST</entry>
       <entry>+09:30 </entry>
       <entry>Central Australia Std Time</entry>
      </row>
      <row>
       <entry>CAST</entry>
       <entry>+09:30 </entry>
       <entry>Central Australia Std Time</entry>
      </row>
      <row>
       <entry>SAT</entry>
       <entry>+9:30</entry>
       <entry>South Australian Std Time</entry>
      </row>
      <row>
       <entry>AWSST</entry>
       <entry>+9:00 </entry>
       <entry>Australia Western Summer Std Time</entry>
      </row>
      <row>
       <entry>JST</entry>
       <entry>+9:00</entry>
       <entry>Japan Std Time,USSR Zone 8</entry>
      </row>
      <row>
       <entry>KST</entry>
       <entry>+9:00</entry>
       <entry>Korea Standard Time</entry>
      </row>
      <row>
       <entry>WDT</entry>
       <entry>+9:00</entry>
       <entry>West Australian Daylight Time</entry>
      </row>
      <row>
       <entry>MT</entry>
       <entry>+8:30</entry>
       <entry>Moluccas Time</entry>
      </row>
      <row>
       <entry>AWST</entry>
       <entry>+8:00 </entry>
       <entry>Australia Western Std Time</entry>
      </row>
      <row>
       <entry>CCT</entry>
       <entry>+8:00 </entry>
       <entry>China Coastal Time</entry>
      </row>
      <row>
       <entry>WADT</entry>
	 <entry>+8:00</entry>
       <entry>West Australian Daylight Time</entry>
      </row>
      <row>
       <entry>WST</entry>
       <entry>+8:00</entry>
       <entry>West Australian Std Time</entry>
      </row>
      <row>
       <entry>JT</entry>
       <entry>+7:30</entry>
       <entry>Java Time</entry>
      </row>
      <row>
       <entry>WAST</entry>
       <entry>+7:00</entry>
       <entry>West Australian Std Time</entry>
	</row>
      <row>
       <entry>IT</entry>
	 <entry>+3:30</entry>
       <entry>Iran Time</entry>
      </row>
      <row>
       <entry>BT</entry>
       <entry>+3:00 </entry>
       <entry>Baghdad Time</entry>
      </row>
      <row>
       <entry>EETDST</entry>
       <entry>+3:00 </entry>
       <entry>Eastern Europe Daylight Savings Time</entry>
      </row>
      <row>
       <entry>CETDST</entry>
       <entry>+2:00 </entry>
       <entry>Central European Daylight Savings Time</entry>
      </row>
      <row>
       <entry>EET</entry>
       <entry>+2:00 </entry>
       <entry>Eastern Europe, USSR Zone 1</entry>
      </row>
      <row>
       <entry>FWT</entry>
       <entry>+2:00</entry>
       <entry>French Winter Time</entry>
      </row>
      <row>
       <entry>IST</entry>
       <entry>+2:00</entry>
       <entry>Israel Std Time</entry>
      </row>
      <row>
       <entry>MEST</entry>
       <entry>+2:00</entry>
       <entry>Middle Europe Summer Time</entry>
      </row>
	<row>
       <entry>METDST</entry>
       <entry>+2:00</entry>
       <entry>Middle Europe Daylight Time</entry>
      </row>
      <row>
       <entry>SST</entry>
       <entry>+2:00</entry>
       <entry>Swedish Summer Time</entry>
      </row>
      <row>
       <entry>BST</entry>
       <entry>+1:00 </entry>
       <entry>British Summer Time</entry>
      </row>
      <row>
       <entry>CET</entry>
       <entry>+1:00 </entry>
       <entry>Central European Time</entry>
      </row>
      <row>
       <entry>DNT</entry>
       <entry>+1:00 </entry>
       <entry>Dansk Normal Tid</entry>
      </row>
      <row>
       <entry>DST</entry>
       <entry>+1:00 </entry>
       <entry>Dansk Standard Time (?)</entry>
      </row>
      <row>
       <entry>FST</entry>
       <entry>+1:00 </entry>
       <entry>French Summer Time</entry>
	</row>
      <row>
       <entry>MET</entry>
       <entry>+1:00</entry>
       <entry>Middle Europe Time</entry>
      </row>
      <row>
       <entry>MEWT</entry>
       <entry>+1:00</entry>
       <entry>Middle Europe Winter Time</entry>
	</row>
      <row>
       <entry>MEZ</entry>
       <entry>+1:00</entry>
       <entry>Middle Europe Zone</entry>
      </row>
      <row>
       <entry>NOR</entry>
       <entry>+1:00</entry>
       <entry>Norway Standard Time</entry>
      </row>
      <row>
       <entry>SET</entry>
       <entry>+1:00</entry>
       <entry>Seychelles Time</entry>
      </row>
      <row>
       <entry>SWT</entry>
       <entry>+1:00</entry>
       <entry>Swedish Winter Time</entry>
      </row>
      <row>
       <entry>WETDST</entry>
       <entry>+1:00</entry>
       <entry>Western Europe Daylight Savings Time</entry>
      </row>
      <row>
       <entry>GMT</entry>
       <entry>0:00</entry>
       <entry>Greenwish Mean Time</entry>
      </row>
      <row>
       <entry>WET</entry>
       <entry>0:00</entry>
       <entry>Western Europe</entry>
      </row>
      <row>
       <entry>WAT</entry>
       <entry>-1:00</entry>
       <entry>West Africa Time</entry>
      </row>
      <row>
       <entry>NDT</entry>
       <entry>-2:30</entry>
       <entry>Newfoundland Daylight Time</entry>
      </row>