Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week', - Mailing list pgsql-patches

From Dirk Raetzel
Subject Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',
Date
Msg-id Pine.CYG.4.58.0503290741350.2132@plinio
Whole thread Raw
In response to Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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


pgsql-patches by date:

Previous
From: Manuel Baena García
Date:
Subject: Re: contrib dbf2sql.pl
Next
From: "Greg Sabino Mullane"
Date:
Subject: Have psql \dD show checks