Hi All,
I have seen some solutions from the past for age calculation. But i have one problem.
I need to check whether a person is less than 19 years.
The sql i used was
select months_between(sysdate, to_date(birth_date, 'YYYYMMDD'))/12
I'm using the date where sysdate is 20150412 and birthDate = 19960413
the answer we get is 19.3407 years though this person is not 19 years yet.
How do i get the accurate age?
Thanks in advance