Hi all,

I'm trying to import a date from a text file in YYYYMMDD format as an integer and MySQL is loading it as '0000-00-00'. I recently upgraded to version 4.1.10a, but previous versions loaded this without a problem.

Here is the load script I am using:

LOAD DATA LOCAL INFILE "c:/users.txt"
INTO TABLE users
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';

and here is a sample text record:

"USERNAME",3,"PASSWORD",99,"FIRSTNAME","LASTNAME", T,"A",1,19910827

The date 19910827 is loaded as 0000-00-00, but earlier 4.0.x versions of MySQL loaded it as '1991-08-27'.

Does anyone know why this is happening?

Thanks,
Tom