SQL query for extracting year from a date

Question

I am trying to create a query that gets only the year from selected dates. I.e. select ASOFDATE from PSASOFDATE; returns 11/15/2012, but I want only 2012. How can I get only the year? I know the YEAR function can be used, but I'm not sure how.

Answer 1

This worked for me:

SELECT EXTRACT(YEAR FROM ASOFDATE) FROM PSASOFDATE;

Answer 2

SELECT date_column_name FROM table_name WHERE EXTRACT(YEAR FROM date_column_name) = 2020