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
+12.5k Golang : Tutorial on loading GOB and PEM files
+28.6k Get client IP Address in Go
+12.8k Golang : syscall.Socket example
+5.5k Golang : Spell checking with ispell example
+17.8k Golang : Get current URL example
+16k Golang : Parse date string and convert to dd-mm-yyyy format
+14.2k Golang : invalid character ',' looking for beginning of value
+4k Linux/Unix/MacOSX : Find out which application is listening to port 80 or use which IP version
+25.9k Golang : Record voice(audio) from microphone to .WAV file
+35.8k Golang : Read a text file and replace certain words
+17.2k Golang : Padding data for encryption and un-padding data for decryption