Re: Date function question

Or, if you just wanted the number of days between two dates:

SQL> select to_char(sysdate, 'J') -
to_char(to_date('28-APR-1972','DD-MON-YYYY'), 'J') from dual;

TO_CHAR(SYSDATE,'J')-TO_CHAR(TO_DATE('28-APR-1972','DD-MON-YYYY'),'J')

                                                                 10171

The "J" date mask returns Julian days - days since December 31, 4713 BC

Abey Joseph wrote:
>
> 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