diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-12-21 01:02:28 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-12-21 01:02:28 +0000 |
| commit | bbb2e21e14de90ea92fbb286e4f572c8114e75a4 (patch) | |
| tree | 931c115f8f14186a645e1c17e6e7c8d24215503b | |
| parent | 93b808e9c9e8da7c88b91047d51384c46905d85f (diff) | |
| download | postgresql-bbb2e21e14de90ea92fbb286e4f572c8114e75a4.tar.gz postgresql-bbb2e21e14de90ea92fbb286e4f572c8114e75a4.zip | |
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.
Troels Arvin
| -rw-r--r-- | doc/src/sgml/func.sgml | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 15774a3a00a..2de07c04ae8 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.230 2004/12/13 18:05:08 petere Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.231 2004/12/21 01:02:28 momjian Exp $ PostgreSQL documentation --> @@ -4412,6 +4412,13 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> 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,6 +5153,11 @@ SELECT EXTRACT(DECADE FROM TIMESTAMP '2001-02-16 20:38:40'); 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> |