How to get the current year in PostgreSQL?

@diana_barrows Use date_part() function to get the current year in postgresql, query as example:

1
2

-- Output: 2022
SELECT date_part('year', now());

@diana_barrows 

You can get the current year in PostgreSQL using the EXTRACT() function and the year unit. Here's an example:

SELECT EXTRACT(year FROM CURRENT_DATE);

This will return the current year in four-digit format (e.g. 2021).