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")
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.
Advertisement
Tutorials
+16k Golang : Defer function inside init()
+4.7k Swift : Get substring with rangeOfString() function example
+5.5k Golang : Embedded or data bundling example
+3.8k Linux/MacOSX : How to symlink a file?
+7.9k Golang : HTTP Routing with Goji example
+7k Golang : Add build version and other information in executables
+21.1k Golang : untar or extract tar ball archive example
+14.8k Golang : Read integer from file into array
+8.2k Mac OSX : Get a process/daemon status information
+4.6k Golang : Get S3 or CloudFront object or file information
+7.1k Golang : Variadic function arguments sanity check example
+8.3k Golang : How to generate Code 39 barcode?