Need help importing date format

Database
Enthusiast

Need help importing date format

I need some help as to how I can import a .csv file with the date format as MMDDYYYY so that it changes to YYYYMMDD. I know you can do a INSERT INTO table.name function and add the FORMAT(column name) function, but I am not exactly sure of the syntax and how to correctly do it. Any help or guidance is appreciated.

Tags (2)