Valid DATE Formats | Data Types and Literals | Teradata Vantage - Valid DATE Formats - Teradata Vantage - Analytics Database

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.