how to get the current year from postgres sql query

Question

how to get the current year from postgresql query, I tried like normal mysql query .But this is not working in postgresql?

SELECT YEAR(CURDATE());

select extract(year from current_date), date_part('year', current_date); — Abelisto
– Abelisto, Commented Jun 27, 2016 at 9:19

Rémy Baron · Accepted Answer · 2016-06-27 09:18:46Z

4

try :

  select to_char(now(),'YYYY')

answered Jun 27, 2016 at 9:18

Rémy Baron

1,4099 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

grepit · Accepted Answer · 2020-07-03 16:31:07Z

2

you could also do this

select date_part('year', CURRENT_DATE);

answered Jul 3, 2020 at 16:31

grepit

22.6k6 gold badges109 silver badges82 bronze badges

user330315 · Accepted Answer · 2020-07-03 17:38:32Z

1

In standard ANSI SQL (which is also supported by Postgres) this would be:

extract(year from current_date)

answered Jul 3, 2020 at 17:38

user330315