> Hi, I've got a csv archive with a date field 15/02/03, how can I load > it to a date field with the mysql date format (ISO ? ) 2003-02-15 ? > > thank you >
I wouldn't mind knowing this too, my work around is doing it in php using fgetcsv to extract the csv data, finding the right rows and columns and formatting the date and inserting that way. Like i use preg_split on the 15/02/03 and change it to 2003-02-15, hmm actually dont know how you would format the 03 part to 2003, could be anything :\ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
