Have you tried this?
SELECT * FROM EMPLOYEE_T WHERE EXTRACT (YEAR FROM EmployeeDateHired) = 1999
2
solved Select only the YEAR from DATE? [duplicate]
Have you tried this?
SELECT * FROM EMPLOYEE_T WHERE EXTRACT (YEAR FROM EmployeeDateHired) = 1999
2
solved Select only the YEAR from DATE? [duplicate]