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.
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.