Oracle sqlldr convert date field with different NLS_DATE_FORMAT I want to load data file which contains date fields in this format:

10-AUG-16


but, my oracle NLS_LANG is "Simplified Chinese_China.ZH16GBK", if I specify date format in control file like this:

dd-Month-YY


It will fail, as it expect data like this:

10-八月 -16 // 八月 means august in Chinese


how can I load this data?
TO_DATE functions accepts the NLS language as an optional parameter .. have you tried pulling it in via SQL*Loader as a CHAR, then do a TO_DATE conversion on it inline?

so your SQL*loader syntax might look like:

  ...
    my_date     CHAR  "TO_DATE(:my_date, 'dd-MON-RR', 'NLS_DATE_LANGUAGE=American')"
  ...


See if that works any better ??