Using The DateForm Setting | Data Types and Literals | Teradata Vantage - The DateForm Setting - Teradata Vantage - Analytics Database

Changing the DateForm setting changes the export data type of DATE values.

Changing the DateForm setting changes the data entry format of dates for new tables, but not for existing tables. To avoid data entry problems, however, you can enter all dates as ANSI DATE literals.

Changing the DateForm setting changes the display of DATE values in new tables, but not in existing tables. Therefore, DATE values display differently for new tables than for old tables. Because views are based on the underlying table, this is true for views of tables as well.

To compare or convert strings to DATE values, the strings must have the same format as the DATE values. Such comparisons can fail after you change the DateForm setting because the DATE format for new tables, views of new tables, and existing macros changes. To avoid format errors in string-to-DATE comparisons, however, you can specify dates as ANSI DATE literals.

Changing the DateForm setting can change the format of DATE values in macros, which can cause the macro to fail.