Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date function question
James,
MONTHS_BETWEEN is more accurate than days/365. I was hoping to for something that'll show me , 27 years and 9 months! :-) Thanks for your help!
"James Hanway" <hanwayj_at_NOSPAM.dfo-mpo.gc.ca> wrote in message
news:38BFEBFF.499D4DE9_at_NOSPAM.dfo-mpo.gc.ca...
> 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