TIMESTAMP_FORMAT

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"