Skip site navigation (1) Skip section navigation (2)

Re: time interval math

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: time interval math
Date: 2012-02-11 03:18:43
Message-ID: jh4mmj$7pm$2@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-sql
On 2012-02-09, Edward W. Rouse <erouse(at)comsquared(dot)com> wrote:

>> the operation abs() is meaninless on the type interval
>> eg: what is abs( '1 month - 32 days + 24 hours'::interval )
>
> If you need to add 30 intervals together, then +- is not meaningless. 

if you stop reading after one line you miss the answer.


-- 
⚂⚃ 100% natural


In response to

pgsql-sql by date

Next:From: Rehan SaleemDate: 2012-02-11 19:53:37
Subject: Calling Postgresql Function to delete user data
Previous:From: David JohnstonDate: 2012-02-10 16:08:11
Subject: Re: update column with multiple values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group