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/
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 |