Hi, using mysql 4.0.24 I'm stuck with a problem importing a CSV-file converting the date in the CSV from MM/DD/YYYY to a mysql table..
I'm trying: LOAD DATA INFILE '/tmp/mydata.csv' INTO TABLE mytable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (recordType, serviceType,STR_TO_DATE(gmtDate,'%m/%d/%Y'); The date in the CSV-file field #3 is in format MM/DD/YYYY and therefore not importet correctly; Obvisouly I'm missing something on how to use functions for columns with LOAD DATA INFILE ? TIA, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]