ANSI/SQL DateTime Data Types - Parallel Data Pump

Teradata Parallel Data Pump Reference
Product
Parallel Data Pump
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

ANSI/SQL DateTime Data Types

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” on page 144 for a description of the fixed‑length CHAR representations for each ANSI/SQL DateTime data types.