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 |