Query to find the list of employees age > 30

SELECT SSN,ENAME

FROM EMP

WHERE DATEDIFF(YEAR, DOB, GETDATE())>30

I wanted query in oracle sql syntax.

Select ename
from emp
where trunc(sysdate-emp.dob) > 30
/

Hai,SELECT ENAME FROM EMPWHERE ROUND(MONTHS_BETWEEN(SYSDATE,EMP_DOB)/12)>30I think this will work for you. If not give reply.

       select FNAME,MNAME,LNAME,BDATE
                  
        FROM EMPLOYEE

        WHERE age>30;

 select   empno, BIRTHDate
 from scott.emp
 where trunc( sysdate,'YEAR') - trunC( BIRTHDate, 'YEAR') > 30

For example if emp table has dob (date of birth) column the query is
SELECT * FROM EMP
WHERE months_between(sysdate,dob)/12>30;

SQL> SELECT ename FROM emp WHERE round(months_between(sysdate,DOB)/12)>=30;

select employeename from employee
where trunc(months-between(sysdate,dob)/12, 0) >= 30

      SELECT *,DATEDIFF(YY,,GETDATE()) AS AGE FROM WHERE DATEDIFF(YY,,GETDATE()) > 30




  Thanks & Regards
  K.santhosh

Please tell me,
How to get age of all employee by using query