importing from text: date column problem

I want to import a text file into a table that has a date type column with mysqlimport. In the text file the date column is in the DD-MMM-YY format (ie 25-JUL-02); so when I import it, I get -00-00 in the table's date column. Is there a way to do this correctly ? My version is 3.23.52. Thank

Re: importing from text: date column problem

] - Original Message - From: Bran Ioan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 1:55 AM Subject: importing from text: date column problem I want to import a text file into a table that has a date type column with mysqlimport. In the text file the date column