Default: If the DATE_FORMAT parameter is not specified, then the NLS_DATE_FORMAT, NLS_LANGUAGE, or NLS_DATE_LANGUAGE environment variable settings (if defined for the SQL*Loader session) are used. If the NLS_DATE_FORMAT is not defined, then dates are assumed to be in the default format defined by the NLS_TERRITORY setting.
Purpose
The DATE_FORMAT parameter specifies a date format that overrides the default value for all date fields.
Syntax and Description
DATE_FORMAT=mask
The mask is a date format mask, normally enclosed in double quotation marks.
Restrictions
None
Example
If the date in the data file was 17-March-2012, then the date format would be specified as follows:
> sqlldr hr TABLE=employees DATE_FORMAT="DD-Month-YYYY"