Week numbering
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.patchtext/x-patch; charset=ISO-8859-15; name=pgsql-day-of-week-docs.patchDownload+12-0
Patch applied. Thanks.
---------------------------------------------------------------------------
Troels Arvin wrote:
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
[ Attachment, skipping... ]
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
--
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