get year from date postgres code example
Example 1: postgresql get year
select extract(year from your_column) from your_table;Example 2: get year from date postgres
SELECT EXTRACT(YEAR FROM column_date);select extract(year from your_column) from your_table;SELECT EXTRACT(YEAR FROM column_date);