The following ANSI/SQL DateTime data types can be specified as column or field modifiers in some of the Teradata SQL statements used with Teradata TPump:
- DATE
- TIME
- TIMESTAMP
- INTERVAL
For example, they can be used in CREATE TABLE statements and in INSERT statements. However, some restrictions may apply when ANSI/SQL DateTime data types are used.
In the FIELD command, the ANSI/SQL DateTime data types must be converted to fixed-length CHAR(10) data types. See Using ANSI/SQL DateTime Data Types for a description of the fixed-length CHAR representations for each ANSI/SQL DateTime data types.