| From: | Jorge Godoy <jgodoy(at)gmail(dot)com> |
|---|---|
| To: | "Hiltibidal, Rob" <Rob(dot)Hiltibidal(at)argushealth(dot)com> |
| Cc: | Ireneusz Pluta <ipluta(at)wp(dot)pl>, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Week to date function |
| Date: | 2010-03-28 01:51:52 |
| Message-ID: | w2w175c742d1003271851l437ca6b2ved5e973ce61e1ca1@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)gmail(dot)com>
On Sat, Mar 27, 2010 at 18:31, Hiltibidal, Rob <
Rob(dot)Hiltibidal(at)argushealth(dot)com> wrote:
> Uhhhh only 52 calendar weeks in a year... I'm almost sure that is the
> norm
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Snyder, James | 2010-03-29 16:25:48 | Re: SQL syntax rowcount value as an extra column in the result set |
| Previous Message | Hiltibidal, Rob | 2010-03-27 21:31:18 | Re: Week to date function |