1: there are so many fields, the content is bigger, every error importing not time, setting the field type is wrong, is there a better way to import
2: I use a vehicle data import navicat but why so much more behind the time using datetime zero, my time is to what time a few minutes, the back is to the minutes, how to get rid of, there is no need to remove, affect use?
3: there is a data analyst, have must learn Python have recommend good introductory lesson, netease clouds occasionally listen to class now, feel also won't listen,
4: big data analysis software of whether to use skilled, such as SPSS and stata, that with a little, please recommend
The couple a more advice

CodePudding user response:

Time to string
The 2019-01-01 kind
20190101153500

SELECT the cast (' 20190101153500 'as a datetime) as aaa

If you want to deal with time in handling import database, suggested that all field data type of varchar