16.20 - Valid DATE Formats - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
Programming Reference

The following table describes the valid DATE formats. The components that make up a valid date format are the same components that make up a DATE string validation. See DATE Data Type.

Using a format with a four-digit year, such as YYYY-MM-DD, is recommended to avoid the Year 2000 problem. To work with two-digit year formats in strings, see the Century Break feature in Teradata Vantageā„¢ - Database Utilities , B035-1102 .

  ANSIDate IntegerDate User-Defined
Field Mode Display Format YYYY-MM-DD YY/MM/DD, or the value of the DATE element in a custom SDF As defined by format
Allowed Input Separators Any non-numeric character Any non-numeric character Any non-numeric character
Export Data Type Character Numeric Depends on DateForm setting
Description ANSI-specified date format. Teradata legacy date format. Custom date format for the system or a DATE column or value.
Example 1999-11-30 99/11/30 Jan 31, 2000