BUG #12432: date_trunc returning wrong year and day - Mailing list pgsql-bugs

From bquirion@gmail.com
Subject BUG #12432: date_trunc returning wrong year and day
Date
Msg-id 20150105191703.11501.36985@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12432: date_trunc returning wrong year and day
Re: BUG #12432: date_trunc returning wrong year and day
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12432
Logged by:          Brian Quirion
Email address:      bquirion@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Linux
Description:

foodb=> select date_trunc('week', now() - interval '1 week');
       date_trunc
------------------------
 2013-12-30 00:00:00-08
(1 row)

foodb=> select date_trunc('week', now() - interval '2 week');
       date_trunc
------------------------
 2014-12-22 00:00:00-08
(1 row)

I'mn using postgres 8.0.3

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12428: Incorrect Code
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #12432: date_trunc returning wrong year and day