Re: BUG #1217: wrong date->number of week conversion

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jean-Luc Lachance <jllachan(at)sympatico(dot)ca>, 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-14 08:57:58
Message-ID: 200408141057.58379.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-14 09:01:47 Re: OpenBSD 3.5, PostgreSQL 8.0.0beta1 make fails
Previous Message Peter Eisentraut 2004-08-14 08:34:38 Re: Turkish downcasting in PL/pgSQL