Problem with months_between
Posted: Tue Feb 19, 2019 4:30 am
Hello
I am having problem in months between function.
Query :- Calculate the age of student.
select stu_name,months_between(sysdate,stu_birth_date)/12 from stu_mast;
Error :- The data content could not be loaded.
Access is denied: MONTHS_BETWEEN in statement [select stu_name,months_between(sysdate,stu_birth_date)/12 from stu_mast;]
Please give me solution of this query.
I am having problem in months between function.
Query :- Calculate the age of student.
select stu_name,months_between(sysdate,stu_birth_date)/12 from stu_mast;
Error :- The data content could not be loaded.
Access is denied: MONTHS_BETWEEN in statement [select stu_name,months_between(sysdate,stu_birth_date)/12 from stu_mast;]
Please give me solution of this query.