Postgresql query current year

In PostgreSQL you can use this:

SELECT * FROM mytable WHERE date_part('year', mydate) = date_part('year', CURRENT_DATE);

The date_part function is available in all PostgreSQL releases from current down to 7.1 (at least).

This is pretty old, but now you can do:

SELECT date_part('year', now()); -> 2020

In the place of now you can pass any timestamp. More on Documentation