Re: BUG #1217: wrong date->number of week conversion - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #1217: wrong date->number of week conversion
Date
Msg-id 200408141057.58379.peter_e@gmx.net
Whole thread Raw
In response to Re: BUG #1217: wrong date->number of week conversion  (Jean-Luc Lachance <jllachan@sympatico.ca>)
List pgsql-bugs
Jean-Luc Lachance wrote:
> This look like it would be nice to have it configurable.
>
> first_day_of_the_week
> first_day_of the_year

Well, this isn't really negotiable.  You can define your own calendar
functions that do this, but the standard ones need to be left alone.
This standard isn't just theoretical, btw.  Over here, many calendars
(pocket, wall) have the week number printed on it, and people say
things like, "we will take care of that in week 37".

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Turkish downcasting in PL/pgSQL
Next
From: Peter Eisentraut
Date:
Subject: Re: OpenBSD 3.5, PostgreSQL 8.0.0beta1 make fails