16.20 - DATEFORM - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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

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

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. You can use the tdlocaledef utility to change the 'YY/MM/DD' default DATE format. For details, see Teradata Vantage™ - Database Utilities , B035-1102 .
INTEGERDATE is the default.
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.
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.