11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/datetime.sgml,v 2.6 2000/02/02 16:21:06 thomas Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/datetime.sgml,v 2.7 2000/03/29 03:57:10 thomas Exp $
33Date/time details
44
55$Log: datetime.sgml,v $
6+ Revision 2.7 2000/03/29 03:57:10 thomas
7+ Change rules for interpreting date/time input to disallow 1 and 3 character
8+ years. Rejects dates like '0.085', which were accepted previously.
9+ Minor mods of ODBC markup.
10+
611Revision 2.6 2000/02/02 16:21:06 thomas
712Add detailed information on Australian time zones.
813
@@ -578,7 +583,7 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
578583
579584 <step>
580585 <para>
581- Iflonger than two digits, then interpret as a year.
586+ Iffour or more digits, then interpret as a year.
582587 </para>
583588 </step>
584589
@@ -605,7 +610,13 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
605610
606611 <step>
607612 <para>
608- Otherwise, interpret as a year.
613+ If two digits or four or more digits, then interpret as a year.
614+ </para>
615+ </step>
616+
617+ <step>
618+ <para>
619+ Otherwise, throw an error.
609620 </para>
610621 </step>
611622 </substeps>
@@ -629,10 +640,10 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
629640 <tip>
630641 <para>
631642Gregorian years 1-99AD may be entered by using 4 digits with leading
632- zeros (e.g. 0099 is 99AD).Three digits are also accepted as a
633- year under most circumstances, though depending on position the
634- numeric string may
635- be interpreted as doy instead .
643+ zeros (e.g. 0099 is 99AD).Previous versions of
644+ <productname>Postgres</productname> accepted years with three
645+ digits and with single digits, but as of v7.0 the rules have
646+ been tightened up to reduce the possibility of ambiguity .
636647 </para>
637648 </tip>
638649 </para>
