17.10 - DateForm - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Defines whether IntegerDate or ANSIDate formatting is used for a session.

Field Group


Valid Settings

Setting Description
0 (IntegerDate) Columns with DATE and PERIOD(DATE) type values use the format specified in the SDF file. The default format is ‘YY/MM/DD’, however the SDF file can be customized by a system administrator to change this date format.
1 (ANSIDate) Date columns are formatted for output as 'YYYY-MM-DD'.


0 (IntegerDate)

Changes Take Effect

For new sessions begun after the DBS Control Record has been written. Existing sessions are not affected.

Usage Notes

DateForm can be overridden at the user level and at the session level (at logon or during the session).

Related Information

For more information on… See…
The SDF file Teradata Locale Definition Utility (tdlocaledef).
DateForm Teradata Vantage™ - SQL Fundamentals, B035-1141.