The following table describes the things to consider when using the DATEFORM command.
| Topic | Usage Notes | |||
|---|---|---|---|---|
| Command Frequency and Placement |
|
|||
| Data Type Conversions | When the ANSIDATE specification is used, the ANSI/SQL DateTime data types must be converted to fixed-length CHAR data types when specifying the column/field names in the Teradata TPump FIELD command. See the FIELD command for a description of the fixed-length CHAR representations for each DATE, TIME, TIMESTAMP, and INTERVAL data type specification. |
|||
| Release Applicability | The ANSIDATE specification is valid for Teradata TPump jobs on the database for a UNIX OS. | |||