From: "Abey Joseph" <abeyj@netzero.net>
Subject: Date function question
Date: 2000/03/03
Message-ID: <89op0a$k27$1@nntp3.atl.mindspring.net>#1/1
X-Priority: 3
X-Server-Date: 3 Mar 2000 16:24:42 GMT
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Organization: MindSpring Enterprises
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.server


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