public inbox for [email protected]
help / color / mirror / Atom feedFrom: Troels Arvin <[email protected]>
To: [email protected]
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:
[text/x-patch] pgsql-day-of-week-docs.patch (1.2K, 2-pgsql-day-of-week-docs.patch)
download | inline diff:
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>
view thread (2+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected]
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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox