Postgres Pro
Downloads
Home   >   mailing lists

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

From Nicholas Vinen
Subject BUG #1649: Date calculation year off-by-one error
Date
Msg-id 20050504235248.62C2FF0B09@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1649: Date calculation year off-by-one error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1649
Logged by:          Nicholas Vinen
Email address:      hb@pg.x256.org
PostgreSQL version: 8.0.1
Operating system:   Gentoo Linux
Description:        Date calculation year off-by-one error
Details:

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)

pgsql-bugs by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: BUG #1646: ERROR: column "mycolumn" is of type boolean
Next
From: "Nicholas Vinen"
Date:
Subject: BUG #1650: Upgraded postgres, problem went away