[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]