Hi Tony,
Tony Shamshad - Home Office wrote:
>
> I am working on trying to import a TEXT file with a date field.
> Following is just to demonstrate the issue. I have taken the 3 field
> from a very large import file just to demonstrate the issue.
>
>
[snipped content of source and .dat file]
>
> "ENTRY" field need to be a date, when I set it to be a
> varchar, the load
> works fine, as soon as I change it to a DATE field in the Destination
> Table I get the following message.
>
> DATALOAD TABLE TEST
> "ID" 1
> "FNAME" 2
> "ENTRY" 3 DEFAULT NULL
> INFILE 'a.txt' SEPARATOR '|' DATE USA
> Error during execution
> -->-25301
> Invalid input for date or time column: 06/30/05
>
The date format USA is defined as: MM/DD/YYYY. So I'd say
change your command to a free format like this
DATALOAD TABLE TEST
"ID" 1
"FNAME" 2
"ENTRY" 3 DEFAULT NULL
INFILE 'a.txt' SEPARATOR '|' DATE 'mm/dd/yy'
and it'll do.
Regards,
Steffen
--
Steffen Schildberg
MaxDB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
