I'm trying to import thousands of dated records from a comma delimited
file into a MySQL table. All of these records have the date as mm/dd/yy.
MySQL according to the documentation will only accept as a DATE datatype,
dates with the year listed first. After importing the data, all dates
read 'March 1, 2000'.
I am aware of the following choices:
1: Change the DATE datatype to VARCHAR.
2: Write some kind of script to rearrange the date format in my
.csv file.
The first seems the easy way, the second I am not capable of. If anyone
has any other suggestions I would be happy to hear them.
TIA,
--
Charles Farinella
[EMAIL PROTECTED]
**********************************************************
To unsubscribe from this list, send mail to
[EMAIL PROTECTED] with the following text in the
*body* (*not* the subject line) of the letter:
unsubscribe gnhlug
**********************************************************
