Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',

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

In response to

Responses

Browse pgsql-bugs by date

  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',

Browse pgsql-patches by date

  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