Golang : Error reading timestamp with GORM or SQL driver

Tags : golang gorm mysql mariadb timestamp parse-time

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")

Tags : golang gorm mysql mariadb timestamp parse-time

By Adam Ng

IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.