Re: date_trunc('week', '2005-01-01'::TIMESTAMP)

On Thu, Sep 22, 2005 at 12:20:58PM +0200, A. Kretschmer wrote:
> am  22.09.2005, um 12:40:00 +0300 mailte pgsql-general@list.coretech.ro folgendes:
> > select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
> > 00:00:00'
>
> Which version?

This bug was fixed in 8.0.2:

http://archives.postgresql.org/pgsql-committers/2005-04/msg00008.php

A similar bug is fixed in CVS, so it'll be in 8.0.4:

http://archives.postgresql.org/pgsql-committers/2005-07/msg00144.php

--
Michael Fuhr