get year from date postgres
snippet in sql

postgresql get year

user8613

select extract(year from your_column) from your_table;

get year from date postgres

user4496

SELECT EXTRACT(YEAR FROM column_date);