Adding one year to a date field in postgresql

Question

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 1

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.

Answer 2

select CURRENT_DATE, CURRENT_DATE + interval '1 year'

In your case you trying to do it in Transact SQL not in Postgres.

Try to use: DATEADD-> "DATE + interval '1 year'"