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
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:
+---+-+
| Field
] 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, 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