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.
| ANSIDATE | INTEGERDATE | User-Defined | |
|---|---|---|---|
| Field Mode Display Format | YYYY-MM-DD | YYYY/MM/DD | 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 |