From: James Hanway <hanwayj@NOSPAM.dfo-mpo.gc.ca>
Subject: Re: Date function question
Date: 2000/03/03
Message-ID: <38BFEBFF.499D4DE9@NOSPAM.dfo-mpo.gc.ca>#1/1
Content-Transfer-Encoding: 7bit
References: <89op0a$k27$1@nntp3.atl.mindspring.net>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Trace: sapphire.mtt.net 952102121 142.176.61.253 (Fri, 03 Mar 2000 12:48:41 AST)
Organization: Business Internet
MIME-Version: 1.0
NNTP-Posting-Date: Fri, 03 Mar 2000 12:48:41 AST
Newsgroups: comp.databases.oracle.server


Is the function MONTHS_BETWEEN of any use to you?

SQL> select months_between(sysdate, to_date('28-APR-1972',
'DD-MON-YYYY'))/12 from dual;

MONTHS_BETWEEN(SYSDATE,TO_DATE('28-APR-1972','DD-MON-YYYY'))/12
---------------------------------------------------------------
                                                     27.8508882


James.


Abey Joseph wrote:
> 
> I am writing a report that shows a bunch of customer data.  I need to
> extract the exact age of the customer.  I am not sure if there is an Oracle
> function that will give me the exact age.  I subtracted the date_of_birth
> from the sysdate and I get the number of days in between.  How can I then
> translate that to years and months? I can divide the days by 365, but the
> margin of error gets bigger, the older the customer is.  Any help is
> appreciated.
> 
> Abey Joseph
> abeyj@netzero.net