I have a question. How can I filter the the date of birth where age is more than 65 years old.
I am a beginner to sql and oracle.
select * from
user_owner.table A
where A.birthdate is not null
and year(3-31-2016)- year(mbr_birthdate) > 65
however, I got an error that year is invalid identifier. I found the codes in google but not sure what does it mean. Any suggestions are appreciated.
***Moderator action (Timo): moved from to space.***