CREATE OR REPLACE FUNCTION FINDAGE(
 DT IN date)
 RETURN NUMBER IS
 AGE NUMBER;
 BEGIN
 AGE:= MONTHS_BETWEEN(SYSDATE,'DT');
 RETURN AGE;
 END;

What is really wrong with the above function?


MAXOOD!

Life is an endless journey towards perfection

__________________
MAXOOD!

Life is an endless journey towards perfection

code_lover:

There are several things I see that are not clear:
  1) The date parameter is not clear as to what "date" value are u passing to the function;
  2) To Compute someones age is: Year of Current Date - Year of DOB (Date of Birth). The months and day are used to indicate if they have had a birthday in the current year.;
  3) Even if you generated a number of months, you should divide that number by 12, converting your answer to years.

Hope this helps.

========================
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Thankyou very much for your feedback.Please go through the code below and let me know if i can improve it further.

CREATE OR REPLACE FUNCTION FINDAGE(
 DOB IN DATE)
 RETURN NUMBER
 IS
 YRS NUMBER;
 BEGIN
 YRS:= ROUND((SYSDATE - DOB)/365);
 RETURN YRS;
 END;

Wonder how can i add exception to it if the user enters wrong information like:
select findage(fgddf) from dual;
instead of
select findage('27-MAY-76') from dual;

MAXOOD!

Life is an endless journey towards perfection