ANSI/SQL DateTime Data Types - Parallel Data Pump

Teradata® Parallel Data Pump Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Data Pump
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
kpf1641281806652.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
ouq1478611619316
Product Category
Teradata Tools and Utilities

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.