Adding one year to date field in postgresql

Question

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

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

but postgres return:

ERROR: year column does not exist

I do not see what is wrong with the proposal

Answer 1

Try the following:

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

It looks like you tried to use a SQL Server function DATEADD()that does not exist in Postgres.