PostgreSQL getting a year from date type as integer

Question

I have a date and I want to get just the year from it as an integer.

@vkp i apologise im really new on pgsql and sql in general and i was confused with the google results as they ended up as dates or characters from extracting. all i needed was a simple integer format on top of that which i thought after seeing the suggestions — LaprimoSiesta
– LaprimoSiesta, Commented Apr 13, 2017 at 17:19

Evan Carroll · Accepted Answer · 2017-04-13 17:05:04Z

18

SELECT extract( year FROM CURRENT_DATE )::int;

answered Apr 13, 2017 at 17:05

Evan Carroll

1

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

Comments

durbnpoisn · Accepted Answer · 2017-04-13 17:03:59Z

-2

It's pretty simple, really...

SELECT year([datecolumn])      
  FROM [yourTable]

Since that will be nothing more than a 4-digit number, you can use it as an integer wherever you go.

answered Apr 13, 2017 at 17:03

durbnpoisn

4,6792 gold badges19 silver badges30 bronze badges

There is no year function in pg.

Ah. I saw SQL tag and went with that.

year() has nothing to do with SQL. It's a SQL Server flub, one of the very many ways it breaks the spec.