CODE EXAMPLE FOR SQL

postgresql get year

select extract(year from your_column) from your_table;