EasyBasic SELECT

Show employees hired this year

The query

SQL

SELECT first_name, last_name, hire_date
FROM employees
WHERE EXTRACT(YEAR FROM hire_date) = EXTRACT(YEAR FROM CURRENT_DATE)
ORDER BY hire_date DESC;

Tested against PostgreSQL 16

Note

“Dynamic year filter using CURRENT_DATE. Works every year without hardcoding.