Character String Format | Character-to-DATE Conversion | Teradata Vantage - 17.10 - Character String Format - 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)

If the dateform of the current session is INTEGERDATE, the date representation in the character string must match the DATE output format according to the rules in the following table.

IF the statement … THEN …
specifies a FORMAT phrase for the DATE the character string must match that DATE format.
does not specify a FORMAT phrase If the DATE column definition:

Specifies a FORMAT phrase, the character string must match the DATE format.

Does not specify a FORMAT phrase, the character string must match ‘YY/MM/DD’, or the current setting of the default date format in the specification for data formatting (SDF) file.

For an example, see Example: IntegerDate Dateform Mode.

If the dateform of the current session is ANSIDATE, the date representation in the character string must match the DATE output format according to the rules in the following table.

IF the statement … THEN …
specifies a FORMAT phrase for the DATE the character string must match that DATE format.
does not specify a FORMAT phrase If in field mode, then if the DATE column definition:
  • Specifies a FORMAT phrase, the character string must match that DATA format.
  • Does not specify a FORMAT phrase, the character string must match the ANSI format ('YYYY-MM-DD')

If in record or indicator mode, the character string must match the ANSI format ('YYYY-MM-DD').