Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: Ryan Kelly <rpkelly22(at)gmail(dot)com>
Cc: afonit(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds
Date: 2013-01-07 17:51:04
Message-ID: CA+mi_8ZdvDV8q03LYtEGdLYrMhvOyfvH6DeD33abH5f2tOP5eQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jan 7, 2013 at 5:47 PM, Ryan Kelly <rpkelly22(at)gmail(dot)com> wrote:

> Alright, now I'm thoroughly confused. What magic makes this true:

"""
Internally interval values are stored as months, days, and seconds.
This is done because the number of days in a month varies, and a day
can have 23 or 25 hours if a daylight savings time adjustment is
involved.
"""

http://www.postgresql.org/docs/9.1/static/datatype-datetime.html

-- Daniele

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tam Tran 2013-01-07 17:54:44 Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds
Previous Message Ryan Kelly 2013-01-07 17:47:26 Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds