需要使用golang在postgreSQL中将日期添加1年

Question

I am using golang and postgreSQL version 9.5.5 in my application. I am using github.com/lib/pq as my database driver to connect to the database. One of my fields(resetdate) have the type date. I would like to add the resetdate by 1 year. So I used the following code:

Note:I m using beego as my framework and use orm to compute my queries.

_, err := o.Raw("UPDATE resetdate=resetdate + interval  '1 year'  WHERE resetdate>=?","2016-12-12").Exec()

When I execute this I'm getting the following error:

"pq: syntax error at or near \"=\""

Appreciate any help.Thanks

Answer 1

I think that problem can be solved including the "SET" in your update statement
_, err := o.Raw("UPDATE TABLE_NAME SET resetdate=resetdate + interval '1 year' WHERE resetdate>=?","2016-12-12").Exec()

Reference: Postgres UPDATE