Re: Week to date function - Mailing list pgsql-sql

From Jorge Godoy
Subject Re: Week to date function
Date
Msg-id w2w175c742d1003271851l437ca6b2ved5e973ce61e1ca1@mail.gmail.com
Whole thread Raw
In response to Week to date function  (Ireneusz Pluta <ipluta@wp.pl>)
List 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@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

pgsql-sql by date:

Previous
From: Ireneusz Pluta
Date:
Subject: Re: Week to date function
Next
From: "Snyder, James"
Date:
Subject: Re: SQL syntax rowcount value as an extra column in the result set