The following table describes the things to consider when using the DATEFORM command.
Topic | Usage Notes |
---|---|
Command Placement and Frequency | Only use one DATEFORM command. The command must be entered before the LOGON command. |
Data Type Conversions | When the ANSIDATE specification is used, ANSI/SQL DateTime data types must be converted to fixed-length CHAR data types when specifying the column/field names in the Teradata FastLoad DEFINE command. See the Input Length and Field Descriptions table in Usage Notes 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 FastLoad jobs. |