Default: The default is taken from the value of the NLS_TIMESTAMP_FORMAT
environment variable. If NLS_TIMESTAMP_FORMAT
is not set up, then timestamps use the default format defined in the NLS_TERRITORY
environment variable, with 6 digits of fractional precision.
Purpose
The TIMESTAMP_FORMAT
parameter specifies a timestamp format to use for the load.
Syntax and Description
TIMESTAMP_FORMAT="timestamp_format"
Restrictions
None
Example
The following is an example of specifying a timestamp format:
> sqlldr hr TABLE=employees TIMESTAMP_FORMAT="MON-DD-YYYY HH:MI:SSXFF AM"