Hello list!
Im loading rows from a txt tab separated fields file into a MySQL table. It mostly works, but the date format in one field is not the type that MySQL likes. So right now Im loading it as a char field. Yes, it is ugly and a pain to work with. I would like to some how automate it and change the time format. >From -> 30-May-05 To -> 2005-05-30 The txt file is initially generated from an excel sheet. Im using: MySQL 4.1.11 on Red Hat 9 with kernel 2.4.20 Any ideas? James Collado