From: | Dirk Raetzel <d00273(at)spaetzle(dot)de> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>, Dirk Raetzel <d00273(at)spaetzle(dot)de>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week', |
Date: | 2005-03-29 05:43:53 |
Message-ID: | Pine.CYG.4.58.0503290741350.2132@plinio |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
On Mon, 28 Mar 2005, Bruce Momjian wrote:
> I have developed a patch to fix the problem. Instead of changing the
> API, I added code to decrement the year when the week number was 53 and
> the month was January. It corrected the problem:
The problem arises as well when week number is 52 as in '2006-01-01'.
Dirk
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2005-03-29 12:25:23 | Re: Background writer process terminating |
Previous Message | Robert Creager | 2005-03-29 04:15:43 | Re: BUG #1563: wrong week returnded by date_trunc('week', |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Creager | 2005-03-29 13:42:09 | Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week', |
Previous Message | Christopher Kings-Lynne | 2005-03-29 05:00:07 | Re: [WIP] shared row locks |