Hi Hendra
An alternative would be to:-
1 LOAD DATA the table, but format each date field as a string.
2 add a date column
3 use UPDATE to convert/re-format the data from the string to date field
4 remove the string column
This solution does not require you to tackle another tool and face the ext
: Friday, January 25, 2002 5:09 AM
Subject: [PHP-DB] problem with LOAD DATA INFILE for date format
> Hi,
>
> I have a sample data like below in text file (policy.txt).
>
> "PolicyNo","DateOfBirth","PaidToDate"
> "0003573607","
Hi,
I have a sample data like below in text file (policy.txt).
"PolicyNo","DateOfBirth","PaidToDate"
"0003573607"," 9/25/1973"," 8/27/2001"
"708802","11/26/1959"," 5/25/1998"
"0002776507"," 3/19/1973","11/18/1999"
"0002776703"," 3/13/1969","11/18/1999"
Policy table structure:
+-