hi
how do i load date format like 1988/01/00 to oracle table using sqlloader.
DAT file look like this
BWED |201747 | 1|1|85/08/16|11|438| 1|1985/08/31|XKR011012|1988/01/00|1988/01/00|99|D| | 47.30| .00|2| |Y| |
BWED |206110 | 1|1|85/12/20|19| 64| 1|1985/12/31|XKS020512|1987/11/00|1988/03/10|99|D| | 69.95| .00|2| |Y| |
Sqlloader error message:
Record 169910: Rejected - Error on table CLAIMS_RECORD, column CLAIM_DATE.
ORA-01847: day of month must be between 1 and last day of month