If the data is on a spreadsheet, then why not use excel to rewrite
the date?
For example, copy the text where the dates are,...then format the
entire column to be "text" and not a date (because excel stores dates
as numbers,...but displays them as dates),...then paste the dates
back into
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 l