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

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

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