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
+5.8k Mac/Linux/Windows : Get CPU information from command line
+6k Golang : Mapping Iban to Dunging alphabets
+7.8k Golang : Apply Histogram Equalization to color images
+6.3k Golang : Rot13 and Rot5 algorithms example
+18.2k Golang : How to Set or Add Header http.ResponseWriter?
+10k How to test Facebook App on localhost ?
+4.4k Golang : Detect words using using consecutive letters in a given string
+23.7k Golang : Convert long hexadecimal with strconv.ParseUint example
+21.1k Golang : Set and Get HTTP request headers example
+11.3k Golang : Sort and reverse sort a slice of bytes
+12.7k Golang : convert rune to unicode hexadecimal value and back to rune character
+7.6k Linux/Unix : fatal: the Postfix mail system is already running