17.00 - SET SESSION DATEFORM Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
ANSIDATE
A DATE format of CHARACTER(10) for the session, formatted as ‘YYYY-MM-DD’ for importing and exporting DATE values.
INTEGERDATE
Encoded integers for importing and exporting DATE values.
When the session DATEFORM is INTEGERDATE, the default DATE format in field mode is 'YY/MM/DD' for date columns created and 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 .