System Default DATE Format - Teradata Vantage - Analytics Database

SQL Data Types and Literals

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
exs1472253032394
lifecycle
latest
Product Category
Teradata Vantageā„¢

The system default DATE format is YYYY-MM-DD (whether DateForm is ANSIDATE or INTEGERDATE).

Your system administrator can change the default format that applies to DATE data types when the DATEFORM is set to INTEGERDATE. Changing the default DATE format involves changing the value of the DATE element in a custom Specification for Data Formatting (SDF) file, and using the tdlocaledef utility to convert the information into an internal form usable by Vantage.

Setting or changing the default DATE format in the SDF has the same consequences as those for DATEFORM, except that the default DATE format in the SDF does not change the export data type of DATE values.

To view the value of the system default DATE format, use HELP SESSION.