TIME
YEAR
MONTH
Returns the year.
YEAR(date)
Enter values below to update the example in real time.
employee_id
hire_date
hire_year
employees
SELECT employee_id, YEAR(hire_date) AS hire_year FROM employees ORDER BY hire_year;
