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.


The DATE_FORMAT parameter specifies a date format that overrides the default value for all date fields.

Syntax and Description


The mask is a date format mask, normally enclosed in double quotation marks.


  • None


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"