At 05:23 AM 5/31/05, James M. Gonzalez wrote:
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?
Change the format of column in Excel before exporting the data.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]