From: Troels Arvin <troels@arvin.dk>
To: pgsql-docs@postgresql.org
Subject: Week numbering
Date: Mon, 06 Dec 2004 11:22:37 +0100
Message-ID: <1102328558.3191.7.camel@localhost> (raw)
Hello,
I was recently surprised to find that EXTRACT's day of the week
numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday
while TO_CHAR starts at 1==Sunday.
A suggestion for two documentation notes is attached as a patch to
current CVS HEAD.
--
Greetings from Troels Arvin, Copenhagen, Denmark
Attachments:pgsql-day-of-week-docs.patch (text/x-patch, 1.2K) download
Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.229
diff -c -r1.229 func.sgml
*** doc/src/sgml/func.sgml 3 Dec 2004 18:34:31 -0000 1.229
--- doc/src/sgml/func.sgml 6 Dec 2004 10:16:57 -0000
***************
*** 4412,4417 ****
--- 4412,4424 ----
1230 microseconds = 2.021230 seconds.
</para>
</listitem>
+ + <listitem>+ <para><function>to_char</function>'s day of the week numbering+ (see the 'D' formatting pattern) is different from that of the + <function>extract</function> function.+ </para>+ </listitem>
</itemizedlist>
</para>
***************
*** 5146,5151 ****
--- 5153,5163 ----
SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
<lineannotation>Result: </lineannotation><computeroutput>5</computeroutput>
</screen>
+ <para>+ Note that <function>extract</function>'s day of the week numbering is + different from that of the <function>to_char</function> function.+ </para>+
</listitem>
</varlistentry>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: troels@arvin.dk
Subject: Re: Week numbering
In-Reply-To: <1102328558.3191.7.camel@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox