Golang : Error reading timestamp with GORM or SQL driver

Problem :

It is common for application to read from database these days and sometimes a missing parameter in the database connection configuration can cause chaos. For instance, while attempting to read time stamp data from database, you get these funky errors :

(sql: Scan error on column index 2: unsupported driver -> Scan pair: []uint8 -> *time.Time)

and when you try to read time stamp from your database(MySQL, SQLite, etc), it becomes :

0001-01-01 00:00:00 +0000 UTC

Solution :

Make sure that your database connection is initialized with parseTime=true parameter.

For example :

dbConn, err := gorm.Open("mysql", "username:password@tcp(xx.xx0.x65.xx4:3306)/dbname?charset=utf8&parseTime=true")