| 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: | Whole Thread | Raw Message | 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 |