Is there anyway to change the default date format (possibly in a .ini or .cfg file) from YYYY-MM-DD to another format ? (ie, mm/dd/yyyy or any user-defined format).
The useage that I'm looking at is to import a CSV file into a table (using Load data infile …. command) where dates are stored in mm/dd/yyyy format and can change based on the source of the data. I can import the date fields into a char field and then convert it but would like to save the time to transform and copy contents into another table.
MySql recognizes dates in various formats, if you are lucky enough, then will transform your data from mm/dd/yyyy format to its own, provided you don't feed date columns as varchar to MySql. It works for me via ADO…