postgresql get year
snippet in sql

postgresql get year

user8212

select extract(year from your_column) from your_table;