|
-
Sql loader issue
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|