I have one problem for my developing pace. To calculate the age.
that is i give the my date of birth like 10-mar-1972
find my age from sysdate.
i.e sysdate - '10-mar-1972'
well how do you want it?
In years, months and days?
select round(months_between(sysdate, to_date('10-Mar-1972', 'dd-Mon-yyyy'))/12)
Below is a function I created for calculating age in years and months.
create or replace function age(dob in date)
str:=yrs||' Years '||mnths||' Months';
Click Here to Expand Forum to Full Width