1

I am using a batch to import csv files with a scheduled task. My batch is as follows:

C:\xampp\mysql\bin\mysqlimport.exe --host=localhost --user=FAKEUSER 
    --password=FAKEPASSWORD --delete --fields-terminated-by="," 
    --ignore-lines=1 --fields-enclosed-by="'" --fields-escaped-by="'"
    --lines-terminated-by="\r\n" insurance C:\import\ins_employees.csv 

The csv I am importing contains hiring dates, leave of absence dates, etc.

How do I use the str_to_date command in my batch so that it will convert the date fields (mm/dd/yyyy) to the proper SQL format?

TimoStaudinger
  • 41,396
  • 16
  • 88
  • 94
Aaron Martin
  • 397
  • 2
  • 6
  • 17

0 Answers0