Postgres Pro
Downloads
Home   >   mailing lists

Re: Absolute value of intervals - Mailing list pgsql-general

From Lew
Subject Re: Absolute value of intervals
Date
Msg-id hcil7v$o2q$2@news.albasani.net
Whole thread Raw
In response to Re: Absolute value of intervals  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Tree view 
Jeff Davis wrote:
> On Thu, 2009-10-29 at 16:39 -0700, Scott Bailey wrote:
>> But there is some ambiguity around the length of a month. So INTERVAL '1
>> month - 30 days' =  INTERVAL '0 days' = INTERVAL '-1 month +30 days'.
>> But when added to a date, it makes no change for months with 30 days,
>> adds 1 day for months with 31 days and subtracts 2 days for February.

or 1 day for February, 2012.

--
Lew

pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: Absolute value of intervals
Next
From: Craig Ringer
Date:
Subject: Re: What order of steps of the postgres when you change information in the table?