From: | Jean-Luc Lachance <jllachan(at)sympatico(dot)ca> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Romuald Pilitowski <rpilitow(at)galera(dot)ii(dot)pw(dot)edu(dot)pl>, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1217: wrong date->number of week conversion |
Date: | 2004-08-13 15:25:18 |
Message-ID: | 411CDD5E.9010704@sympatico.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
This look like it would be nice to have it configurable.
first_day_of_the_week
first_day_of the_year
Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
>
>>Frankly speaking I don`t know the adequate calendar ISO norm in detail, but
>>the last days of year shouldn`t be counted as F_I_R_S_T week of that year. I
>>expected PostgreSQL rather to return 2003-53-29.
>
>
> You are mistaken.
>
> The ISO week is defined as Mon-Sun where week 1 of a year is the week
> containing the year's first Thursday. Don't ask me *why* it's defined
> that way, but it is. 2004's first Thursday is Jan 1, so that week
> extends from 2003-12-29 to 2004-01-04.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Verbus M. Counts | 2004-08-13 18:13:13 | Re: regression test failure on 8.0.0beta1 |
Previous Message | Tom Lane | 2004-08-13 14:48:06 | Re: postgresql 8.0.0 beta1 |