Postgresql query current year

Question

I need to see only the current year rows from a table.

Would it be possible filter a timestamp column only by current year parameter, is there some function that can return this value?

SELECT * FROM mytable WHERE "MYDATE" LIKE CURRENT_YEAR

Answer 1

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).

Answer 2

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