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 have the type timestamp with timezone. I would like to update to the current time. 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 leave SET resultdate=? WHERE leaveid=?", time.Now(), leaveResult.LeaveId).Exec()
When I execute this I'm getting the following error:
"pq: invalid input syntax for type timestamp with time zone: \"09:24:29\""
Appreciate any help.