Valid DATE Formats | Data Types and Literals | Teradata Vantage - 17.10 - Valid DATE Formats - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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