Importing diff format date to MySQL

Hi, I have data in CSV format file which has a date value in the format 'dd/mm/yy'? When i used 'Load data...' to import to a MySQL table, all the fields gets the value from the file except the date field that contains the date of birth?? is there any way to format and import??? Thanks Regards

re: Importing diff format date to MySQL

Sankaranarayanan, Friday, October 11, 2002, 7:15:30 AM, you wrote: SM I have data in CSV format file which has a date value SM in the format 'dd/mm/yy'? SM When i used 'Load data...' to import to a MySQL table, SM all the fields gets the value from the file except the SM date field that contains