DATEFORM - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Default format for importing and exporting DATE values for the user.

DATEFORM = INTEGERDATE is the default.

For further information, see Teradata Vantage™ - Data Types and Literals, B035-1143.

ANSIDATE
Sets the DATEFORM option to import and export DATE values as CHARACTER(10).
Results in a 'YYYY-MM-DD' date format for date columns created and for date constants in character form.
INTEGERDATE
Sets the DATEFORM option to import and export DATE values as encoded integers.
INTEGERDATE results in a default DATE format in field mode of 'YY/MM/DD' for date columns created and for date constants in character form. The 'YY/MM/DD' default DATE format can be changed by using the tdlocaledef utility. For details, see Teradata Vantage™ - Database Utilities , B035-1102 .
INTEGERDATE is the default.
NULL
Sets DATEFORM null.
When DATEFORM is null, the default format for a date in field mode, and the default format for importing and exporting DATE values, is the same as the system default defined by the DATEFORM parameter in the DBS Control record.