CODE EXAMPLE FOR SQL

get year from date postgres

SELECT EXTRACT(YEAR FROM column_date);