DATEFORM

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

Product Category

Teradata Tools and Utilities

The DATEFORM command lets you define the form of the DATE data type specifications for the Teradata TPump job.

where

Syntax Element

Description

INTEGERDATE

Keyword that specifies integer DATE data types for the Teradata TPump job

This is the default Teradata DATE data type specification for Teradata TPump jobs if you do not enter a DATEFORM command.

ANSIDATE

Keyword that specifies ANSI fixed‑length CHAR(10) DATE data types for the Teradata TPump job

Table 27 describes the things to consider when using the DATEFORM command.

Table 27: DATEFORM Command Usage Notes
Topic	Usage Notes
Command Frequency and Placement	Only one DATEFORM command can be used. The DATEFORM command must be entered before LOGON command.
Data Type Conversions	When the ANSIDATE specification is used, the ANSI/SQL DateTime data types must be converted to fixed‑length CHAR data types when specifying the column/field names in the Teradata TPump FIELD command.
	See the FIELD command 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 TPump jobs on Teradata Database for a UNIX OS.