Re: Absolute value of intervals

From: Lew <noone(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Absolute value of intervals
Date: 2009-11-01 00:37:19
Message-ID: hcil7v$o2q$2@news.albasani.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-11-01 07:04:16 Re: What order of steps of the postgres when you change information in the table?
Previous Message Lew 2009-11-01 00:35:04 Re: Absolute value of intervals