Re: BUG #2046: defective date_trunc

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Chris <termi(at)wp(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2046: defective date_trunc
Date: 2005-11-15 17:16:23
Message-ID: 20051115171623.GH5868@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris wrote:

> Postgresql 8.0
>
> select date_trunc('week',TO_DATE('2005-01-01','yyyy-mm-dd'))

Upgrade to 8.0.4. This bug is fixed there.

alvherre=# select date_trunc('week',TO_DATE('2005-01-01','yyyy-mm-dd'));
date_trunc
------------------------
2004-12-27 00:00:00-03
(1 fila)

alvherre=# select version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.2 20050806 (prerelease) (Debian 4.0.1-4)
(1 fila)

alvherre=#

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Eugene Chow 2005-11-16 01:25:37 Assigning null to an array element in plpgsql
Previous Message Stephan Fischer 2005-11-15 16:21:26 [postgres] pgcluster