golang现在用松鼠更新设置时间

Question

Right now my container's timezone is different with MySQL's, and I need to run a query to just update the time field on MySQL to its timezone. Normally, I can run the query with "edited=NOW()", but with the Golang squirrel, it does not have a proper way to set this clause. I cannot change both my app and mysql container's timezone, and I just need to update the date in DB. Is there any way to do in Squirell properly?

Answer 1

Instead of Set(column, "NOW()"), you need to do Set(column, sq.Expr("NOW()"))