Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1649: Date calculation year off-by-one error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1649: Date calculation year off-by-one error
Date
Msg-id 23108.1115302531@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1649: Date calculation year off-by-one error  ("Nicholas Vinen" <hb@pg.x256.org>)
List pgsql-bugs
Tree view 
"Nicholas Vinen" <hb@x256.com> writes:
> This is definitely not right:

> rt3=# SELECT date_trunc('week', timestamp with time zone '2005-01-02
> 00:00:00-7');
>        date_trunc
> ------------------------
>  2006-01-02 00:00:00-08
> (1 row)

Already fixed in 8.0.2.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Dirk Bade"
Date:
Subject: BUG #1647: shows version 7.1, doesnt create tablespaces etc.
Next
From: Michael Fuhr
Date:
Subject: Re: BUG #1647: shows version 7.1, doesnt create tablespaces etc.