11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/datetime.sgml,v 2.4 1999/06/23 06:17:51 thomas Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/datetime.sgml,v 2.5 1999/10/12 13:57:04 thomas Exp $
33Date/time details
44
55$Log: datetime.sgml,v $
6+ Revision 2.5 1999/10/12 13:57:04 thomas
7+ Sequence of date interpretation not quite right.
8+
69Revision 2.4 1999/06/23 06:17:51 thomas
710Clarify input/output timezone information.
811Add detail on exact interpretation of "concatenated date"
@@ -425,13 +428,13 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
425428 then <literal>EST</literal> refers to Australia Eastern Std Time,
426429 which has an offset of +10:00 hours from UTC.
427430 </para>
428- </note>
429- </para>
430431
431- <para>
432- Australian time zones and their naming variants
433- account for fully one quarter of all time zones in the
434- <productname>Postgres</productname> time zone lookup table.
432+ <para>
433+ Australian time zones and their naming variants
434+ account for fully one quarter of all time zones in the
435+ <productname>Postgres</productname> time zone lookup table.
436+ </para>
437+ </note>
435438 </para>
436439
437440 <procedure>
@@ -488,12 +491,13 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
488491 Do a binary-search table lookup for the token
489492 as either a special string (e.g. <literal>today</literal>),
490493 day (e.g. <literal>Thursday</literal>),
491- month (e.g. <literal>January</literal>), or noise word (e.g. <literal>on</literal>).
494+ month (e.g. <literal>January</literal>),
495+ or noise word (e.g. <literal>on</literal>).
492496 </para>
493497 <para>
494498 Set field values and bit mask for fields.
495- For example, set year, month, day for <literal>today</literal>,and additionally
496- hour, minute, second for <literal>now</literal>.
499+ For example, set year, month, day for <literal>today</literal>,
500+ and additionally hour, minute, second for <literal>now</literal>.
497501 </para>
498502 </step>
499503
@@ -524,7 +528,7 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
524528 and if no other date fields have been previously read, then interpret
525529 as a "concatenated date" (e.g. <literal>19990118</literal>). 8
526530 and 6 digits are interpreted as year, month, and day, while 7
527- and 5 digits are interpreted as year, day of year.
531+ and 5 digits are interpreted as year, day of year, respectively .
528532 </para>
529533 </step>
530534
@@ -550,22 +554,15 @@ Finish initial markup of cvs.sgml, and include it in the programmer's guide
550554
551555 <step>
552556 <para>
553- Ifin non-European (US) date mode, and if the month field has not yet been read,
557+ If the month field has not yet been read,
554558 and if the value is less than or equal to 12, then interpret as a month.
555559 </para>
556560 </step>
557561
558562 <step>
559563 <para>
560564 If the day field has not yet been read,
561- and if the value is less than or equal to 31, then interpret as a month.
562- </para>
563- </step>
564-
565- <step>
566- <para>
567- If the month field has not yet been read,
568- and if the value is less than or equal to 12, then interpret as a month.
565+ and if the value is less than or equal to 31, then interpret as a day.
569566 </para>
570567 </step>
571568
