Adding one year to a date field in postgresql

Emilio Galarraga picture Emilio Galarraga · Jan 26, 2017 · Viewed 31.2k times · Source

I have a table in postgresql with a field_date using the syntax 'YYYY-MM-DD', I want to add a year to the field with the the sentence:

UPDATE table SET date_field = DATEADD(YEAR, 1, date_field);

but postgres return:

ERROR: column "year" does not exist

I can't see what's wrong with the sentence

Answer

Tim Biegeleisen picture Tim Biegeleisen · Jan 26, 2017

Try this:

UPDATE table SET date_field = date_field + interval '1 year'

It appears that you were trying to use SQL Server's DATEADD() function, which does not exist in Postgres.