year from timestamp postgresql code example

Example 1: postgresql get year

select extract(year from your_column) from your_table;

Example 2: postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;