Message-ID: <479D3E63.2080601@obviously.com>
Date: Sun, 27 Jan 2008 18:30:59 -0800
From: Bryce Nesbitt <bryce1@obviously.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.8.1.11) Gecko/20070803 SUSE/1.1.7-0.1 SeaMonkey/1.1.7
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: extract or date_part on an interval?  How many e
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hmm.  Seemed so simple.  But how do I get the number of years an
interval represents?  extract is clearly the wrong way:

stage=# select 'now()-'1987-02-01' as interval,extract(year from
now()-'1987-02-01') as age;
        interval          | age
--------------------------+-----
7665 days 18:05:51.660345 |   0

select EXTRACT(year FROM INTERVAL '7665 days'); gives the same result.

select EXTRACT(day FROM now()-'1987-02-01')/365 as age; seems messy.
select (now()-'1987-02-01')/365; gives extraneous junk.

 Thanks!

-- 
----
Visit http://www.obviously.com/