Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date function question
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_at_netzero.net
Received on Fri Mar 03 2000 - 00:00:00 CST