SYNTAX: select (sysdate - to-date('05-mar-1991')) "No,of Days" From dual ;
RESULT : No,of Days
7043,9634490740740740740740740707407407
13.02 How to use add_months(
) function
Retirement date by adding 12 * 60 months from 05-mar-1991
SYNTAX: select add-months( to-date('05-mar-
1991'),(12*60)) "Retirement date" From dual ; RESULT :
Retirement-date
05-Mar-51
Finding Birth day from Retirement date by subtracting 12 * 60 months from 05-mar-
2010
SYNTAX: select add-months( to-date('05-mar-
2010'),-(12*60)) "Birth Date" From dual ; RESULT :
Birth Date
- - - - - - -