EasyBasic SELECT

Select employees hired in the year 2023

The query

SQL

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

Tested against PostgreSQL 16

Note

“EXTRACT pulls date parts: YEAR, MONTH, DAY, HOUR, MINUTE, etc.