Re: Importing Dates

[Lachlan Mulcahy]

Hi Doug,

Unfortunately your best bet is to have a preprocesser script run over your file and replace those two date formats with 'YYYY-MM-DD' or any of the other formats accepted by the temporal field types that MySQL has.

I recommend you check out the documention here:

http://dev.mysql.com/doc/mysql/en/datetime.html

It has specific information on what kinds of formats are allowed.

Kind Regards,

Lachlan Mulcahy, Melbourne, Australia
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification