Re: Week to date function

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Week to date function
Дата
Msg-id w2w175c742d1003271851l437ca6b2ved5e973ce61e1ca1@mail.gmail.com
обсуждение исходный текст
Ответ на Week to date function  (Ireneusz Pluta <ipluta@wp.pl>)
Список 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 по дате отправления:

Предыдущее
От: Ireneusz Pluta
Дата:
Сообщение: Re: Week to date function
Следующее
От: "Snyder, James"
Дата:
Сообщение: Re: SQL syntax rowcount value as an extra column in the result set