unsupported Scan, storing driver.Value type []uint8 into type *time.Time

Alright, I found the solution, thanks this answer.
The problem goes by adding ?parseTime=true to the db mapper. Like this:

db, err := sqlx.Connect("mysql", "myuser:mypass@tcp(127.0.0.1:3306)/mydb?parseTime=true")