【Q】how to scan mysql DATE_TIME into golang time.Time about gendry HOT 11 CLOSED

Actually, this is a bug. If you don't set parseTime=true when initialize the sql.DB, the mysql driver won't parse datetime type, thus it returns a []uint8 to gendry. Gendry will convert it to string or something else, but lost the case of time! Gendry should have been smarter to handle this case, and I'll fix it as soon as possible
But for now, the workaround is set parseTime=true

from gendry.

@caibirdme int64

gendry will convert []uint8 to int automatically. I suggest that you can confirm the data in your mysql, is that data able to convert to int

from gendry.

@caibirdme

cool, how could I set this option?

from gendry.

@caibirdme

cool, how could I set this option?

Fixed

from gendry.

@caibirdme Thx for your contribution. But, we have pined on a specific version, and the upgrade could be hard.

So how could I use the parseTime=true to work around this?

from gendry.

see the example code

from gendry.

ApplyApp.UserID is int which is not AssignableBy []uint8

another problem. how about this? @caibirdme

from gendry.

int64 type in mysql

from gendry.

ApplyApp.UserID is int which is not AssignableBy []uint8

another problem. how about this? @caibirdme

What's the type of that column in the table?

from gendry.

@caibirdme int64

from gendry.

thx

from gendry.