(i want to create function with two parmeters(date_of_birth,current_date

to get age in years,months,days

i create this function

 

>>>>>>>>>>>>>>>

create or replace function get_age (p_date_of_birth in date ,p_current_date in date)

return number

is v_get_age number;

begin

select trunc((months_between(to_date(p_current_date),to_date(p_date_of_birth))/12)||' years ' ||

trunc(mod(months_between(to_date(p_current_date),to_date(p_date_of_birth)),12)) ||' months ' || 

trunc(mod(mod(months_between(to_date(p_current_date),to_date(p_date_of_birth)),12),4)) ||' days ' )AS "Age"

into v_get_age

from dual;

return v_get_age;

end;

 

>>>>>>>>>>>>> it created function but the statment if seprated it comes error i want solve this create also how to call this function?????

I get it the answer

 

 

 

thank u .......