From: | Ryan Kelly <rpkelly22(at)gmail(dot)com> |
---|---|
To: | Daniele Varrazzo <daniele(dot)varrazzo(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:47:26 |
Message-ID: | 20130107174726.GB18868@llserver.lakeliving.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Mon, Jan 01/07/13, 2013 at 05:42:40PM +0000, Daniele Varrazzo wrote:
> On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly <rpkelly22(at)gmail(dot)com> wrote:
>
> > '1 month'::interval is the same as '30 days'::interval.
>
> No, it's not.
>
> # select '2012-07-31'::date + '1 month'::interval, '2012-07-31'::date
> + '30 days'::interval;
> ?column? | ?column?
> ---------------------+---------------------
> 2012-08-31 00:00:00 | 2012-08-30 00:00:00
>
> -- Daniele
Alright, now I'm thoroughly confused. What magic makes this true:
# select '30 days'::interval = '1 month'::interval;
?column?
----------
t
But not this:
# select '2012-07-31'::timestamp + '1 month'::interval = '2012-07-31'::timestamp + '30 days'::interval;
?column?
----------
f
?
-Ryan Kelly
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2013-01-07 17:51:04 | Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds |
Previous Message | Daniele Varrazzo | 2013-01-07 17:42:40 | Re: BUG #7797: datetime + '1 month'::interval is going outside of a month's bounds |