Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 31 Oct 2009 20:37:19 -0400
- Message-id: <hcil7v$o2q$2@news.albasani.net> <text/plain>
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
- References:
- Absolute value of intervals
- From: Joshua Berry
- Re: Absolute value of intervals
- From: Sam Mason
- Re: Absolute value of intervals
- From: Tom Lane
- Re: Absolute value of intervals
- From: Scott Bailey
- Re: Absolute value of intervals
- From: Jeff Davis
- Absolute value of intervals
- Prev by Date: Re: Absolute value of intervals
- Previous by thread: Re: Absolute value of intervals
- Next by thread: Re: Absolute value of intervals
- Indexes: