Re: BUG #1649: Date calculation year off-by-one error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nicholas Vinen" <hb(at)x256(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1649: Date calculation year off-by-one error
Date: 2005-05-05 14:15:31
Message-ID: 23108.1115302531@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Nicholas Vinen" <hb(at)x256(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-05-05 14:27:30 Re: BUG #1647: shows version 7.1, doesnt create tablespaces etc.
Previous Message Tom Lane 2005-05-05 13:33:56 Re: BUG #1643: dbf2pg broken + quick fix