X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4F090D1D08C for ; Thu, 15 Apr 2004 01:47:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 47116-03 for ; Thu, 15 Apr 2004 01:47:00 -0300 (ADT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 2DD8DD1CCB0 for ; Thu, 15 Apr 2004 01:46:58 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i3F4l1E13931 for pgsql-docs@postgresql.org; Thu, 15 Apr 2004 00:47:01 -0400 (EDT) From: Bruce Momjian Message-Id: <200404150447.i3F4l1E13931@candle.pha.pa.us> Subject: Clarification of DateStyle To: PostgreSQL-documentation Date: Thu, 15 Apr 2004 00:47:01 -0400 (EDT) X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=ELM1082004421-4285-0_ Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/8 X-Sequence-Number: 2352 --ELM1082004421-4285-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII I have applied the following patch to clarify the meaning of the second DateStyle field. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 --ELM1082004421-4285-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain Content-Disposition: inline; filename="/bjm/diff" Index: runtime.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/runtime.sgml,v retrieving revision 1.258 diff -c -c -r1.258 runtime.sgml *** runtime.sgml 7 Apr 2004 05:05:49 -0000 1.258 --- runtime.sgml 15 Apr 2004 04:45:46 -0000 *************** *** 2433,2449 **** date style ! Sets the display format for date and time values, as well as ! the rules for interpreting ambiguous date input values. ! For historical reasons, this variable contains two independent components: the output format specification (ISO, ! Postgres, SQL, or German) and ! the date field order specification (DMY, MDY, ! or YMD). These can be set separately or together. ! The keywords Euro and European are synonyms ! for DMY; the keywords US, NonEuro, ! and NonEuropean are synonyms for MDY. ! See for more information. The default is ISO, MDY. --- 2433,2450 ---- date style ! Sets the display format for date and time values, as well as the ! rules for interpreting ambiguous date input values. For ! historical reasons, this variable contains two independent components: the output format specification (ISO, ! Postgres, SQL, or German) ! and the input/output specification for year/month/day ordering ! (DMY, MDY, or YMD). These ! can be set separately or together. The keywords Euro ! and European are synonyms for DMY; the ! keywords US, NonEuro, and ! NonEuropean are synonyms for MDY. See ! for more information. The default is ISO, MDY. --ELM1082004421-4285-0_--