DATEFORM | Usage Notes | Teradata FastLoad - 17.10 - Usage Notes - FastLoad

Teradata® FastLoad Reference

Release Number
June 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)

The following table describes the things to consider when using the DATEFORM command.

Usage Notes for DATEFORM 
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.