BUG #6656: Wrong timestamptz + interval calculation

From: mw(at)hesotech(dot)de
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6656: Wrong timestamptz + interval calculation
Date: 2012-05-21 18:38:29
Message-ID: E1SWXUz-0002tb-Qc@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6656
Logged by: Marcus Wirsing (Hesotech GmbH)
Email address: mw(at)hesotech(dot)de
PostgreSQL version: 9.1.3
Operating system: Windows 7 64Bit
Description:

When I execute the statement

select timestamptz '2012-03-01 00:00:00+00' + interval '1 month'

I expect the result:
"2012-04-01 02:00:00+02"

but postgres returns:

"2012-04-01 01:00:00+02"

My local time zone is UTC+1.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Dunstan 2012-05-21 18:59:34 Re: 9.2beta1 regression: pg_restore --data-only does not set sequence values any more
Previous Message gloria_evelis 2012-05-21 17:50:24 BUG #6655: restore backup