Re: BUG #2046: defective date_trunc - Mailing list 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.