Date function example
The following statement extracts the year value from a DATE field:
SELECT EXTRACT(YEAR FROM HIRE_DATE)
FROM EMPLOYEE