DateFormat
The DateFormat defines the default date format that the High-speed Apply Engine uses when it updates date columns in an Oracle target database.
Attributes
This parameter has the following attributes:
Attribute | Value |
---|---|
Section | [StartUp] |
Abbreviation | None |
DBMS | Oracle |
Required? | No |
Valid values | Any valid Oracle date format mask For example: 'MM/DD/YYYY' |
Default value | None |
Usage
Specify a valid Oracle date format mask that matches the dates in your input.
Consider the following points regarding this parameter:
- Use this parameter when your input was generated in another Oracle environment (or on a DBMS other than Oracle) that uses a different date format than the format of the date columns in your target tables. When you specify this parameter, the High-speed Apply Engine issues an ALTER SESSION SET statement to change the date format (the nls_date_format parameter).
- For valid date format masks, consult the Oracle DBMS technical documentation.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*