how to select year from date in postgresql code example Example: get year from date postgres SELECT EXTRACT(YEAR FROM column_date);