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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: date_trunc('week', '2005-01-01'::TIMESTAMP)
Date: 2005-09-22 14:06:50
Message-ID: 20050922140650.GA96052@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)list(dot)coretech(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Андрей 2005-09-22 14:11:36 wrong protocol sequence?
Previous Message Jan Wieck 2005-09-22 13:55:10 Re: Cost based SELECT/UPDATE