postgres query date a year code example

Example 1: get year from date postgres

SELECT EXTRACT(YEAR FROM column_date);

Example 2: postgre query date

SELECT * FROM data WHERE date = '2020-12-21'