Deviopath › PostgreSQL

Year of Hiring

Easy · Dates

EXTRACT(YEAR FROM date) pulls one part out of a date. You can also extract MONTH, DAY and more.

For every employee, return first_name and hire_year (the year of hired_on, like 2021).

Next: Products per Category