From: Jorge Godoy <jgodoy@gmail.com>
To: Hiltibidal, Rob <Rob.Hiltibidal@argushealth.com>
Cc: Ireneusz Pluta <ipluta@wp.pl>
Cc: Sergey Konoplev <gray.ru@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Week to date function
Date: Sat, 27 Mar 2010 22:51:52 -0300
Message-ID: <w2w175c742d1003271851l437ca6b2ved5e973ce61e1ca1@mail.gmail.com> (raw)
In-Reply-To: <40FB2AE5907F9743A593A85015F157BF03FE1086@ARG-EXVS03.corp.argushealth.com>
References: <4BAB2C15.8090406@wp.pl>
<c3a7de1f1003250244p440b8244t57319b742fa680f0@mail.gmail.com>
<4BAC9107.5070701@wp.pl>
<m2w175c742d1003271108p773ebaa7y4fedf008762ed12c@mail.gmail.com>
<4BAE68FA.8000803@wp.pl>
<40FB2AE5907F9743A593A85015F157BF03FE1086@ARG-EXVS03.corp.argushealth.com>
It isn't. The norm is defined by ISO 8601.
There is a lot of "fun" into date calculations.
The rule is to counts the number of Thursdays on a year to get the correct
number of weeks.
What bothers me more is that here it is cultural that weeks start on Sunday,
but ISO 8601 says they start on Monday. In Portuguese, the word for Monday
can also be translated as "Second", as in "Second day". How to say that the
second day is in fact the first? :-)
--
Jorge Godoy <jgodoy@gmail.com>
On Sat, Mar 27, 2010 at 18:31, Hiltibidal, Rob <
Rob.Hiltibidal@argushealth.com> wrote:
> Uhhhh only 52 calendar weeks in a year... I'm almost sure that is the
> norm
>
>
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-sql@postgresql.org
Cc: jgodoy@gmail.com, Rob.Hiltibidal@argushealth.com, ipluta@wp.pl, gray.ru@gmail.com
Subject: Re: Week to date function
In-Reply-To: <w2w175c742d1003271851l437ca6b2ved5e973ce61e1ca1@mail.gmail.com>
* 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