select trunc(months_between(to_date('01/06/2003','MM/DD/YYYY'),
to_date('10/15/1992','MM/DD/YYYY'))/12)
||' years '||
mod(trunc(months_between(to_date('01/06/2003','MM/DD/YYYY'),
to_date('10/15/1992','MM/DD/YYYY'))),12)
||' months '||
trunc(to_date('01/06/2003','MM/DD/YYYY') -
add_months(to_date('10/15/1992','MM/DD/YYYY'),
months_between(to_date('01/06/2003','MM/DD/YYYY'),
to_date('10/15/1992','MM/DD/YYYY'))))
||' days' "Year_Month_Day"
from dual;
Quote:
| Originally Posted by rabindra Hi,
I want no number of days between two selected dates and before you say - you dumbo....here is the catch
I want only number of working days! Is it possible to do it in oracle?
Thanks in advance. |