Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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

- - - - - - -