PostgreSQL getting a year from date type as integer

Question

I have a date and I want to get just the year from it as an integer.

Answer 1

Use extract

SELECT extract( year FROM CURRENT_DATE )::int;