1: time is 2020 navicat import CSV table display show in 2001 and the back of the string out several 0
2: number 20103039485 after import shown behind the 20103000000 become 0 not how to deal with the
Solution, as shown in figure

CodePudding user response:

Before encountered this problem, because the format of the questions, try you see into character

CodePudding user response:

You change the date/time format in the CSV data table should date/time format is ok,
Such as: 2020/1/1 0:14:56 into the 2020-01-01 00:12:56