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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.