I have difficulty querieing for users, which is defined as:

    type User struct {
    	ID           int       `db:&quot;id&quot; json:&quot;id&quot;`            
    	UserName     string    `db:&quot;username&quot; json:&quot;username&quot;` 
    	Email        string    `db:&quot;email&quot; json:&quot;email&quot;`
    	CreatedAt    time.Time `db:&quot;created_at&quot; json:&quot;created_at&quot;`
    	StatusID     uint8     `db:&quot;status_id&quot; json:&quot;status_id&quot;`
    	Deleted      uint8     `db:&quot;deleted&quot; json:&quot;deleted&quot;`
    ... 
    }

And the table in MariaDB is defined as:

    +--------------+------------------+------+-----+-------------------+----------------+
    | Field        | Type             | Null | Key | Default           | Extra          |
    +--------------+------------------+------+-----+-------------------+----------------+
    | id           | int(10) unsigned | NO   | PRI | NULL              | auto_increment |
    | username     | varchar(50)      | NO   |     | NA                |                |
    | email        | varchar(255)     | NO   |     | NULL              |                |
    | created_at   | datetime         | NO   |     | CURRENT_TIMESTAMP |                |
    | status_id    | tinyint(1)       | NO   |     | 0                 |                |
    | deleted      | tinyint(1)       | NO   |     | 0                 |                |
    ...              |

However when I query it like:

    func GetUsers(c *gin.Context) {
    	var users []model.User
    	err := shared.Dbmap.Select(&amp;users, &quot;SELECT * FROM user&quot;)
    
    	if err == nil {
    		c.JSON(200, users)
    	} else {
    		fmt.Println(&quot;%v \n&quot;, err)
    		c.JSON(http.StatusInternalServerError, gin.H{&quot;error&quot;: &quot;no user(s) in the table or problem in the query&quot;})
    	}
    
    	// curl -i http://127.0.0.1:8080/api/v1/users
    }

I get this error:

    sql: Scan error on column index 3: unsupported Scan, storing driver.Value type []uint8 into type *time.Time

while there are some rows in the table. 

I have also tried `	created_at` as 	`timestamp` but still get the same error.

So I&#39;m left clueless as what wrong here? How can I fix it? 

**P.S.** Though my question turned out to have the same answer as [this][1] but here the context is different (`sqlx` instead of `go-sql-driver/mysql`). Also since here the error is the subject it probably more searchable for people who google the same error. So perhaps this worth keeping as a separate question. 


  [1]: https://stackoverflow.com/questions/29341590/go-parse-time-from-database

All Sqlx Solutions on Gang of Coders

Total of 1 Sqlx Solutions

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