Date function question

From: Abey Joseph <abeyj_at_netzero.net>
Date: 2000/03/03
Message-ID: <89op0a$k27$1@nntp3.atl.mindspring.net>#1/1

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_at_netzero.net Received on Fri Mar 03 2000 - 00:00:00 CST