I have text file delimited with '|'.
emp_id|DOB(mm-dd-yyyy)|DOJ(dd/mm/yyyy) *DOJ - Date of joining
.IMPORT VARTEXT '|' FILE=C:ABC.txt;
INSERT INTO my_db.my_emp_tb
==> ERROR 2666 : Invalid date supplied.
Could anybody please tell me how to import these date formats?
It working fine with date format 'YYYY-MM-DD'.