16.20 - literal - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

One or more literal values. A literal may be any of the following:

  • Defined value
  • Macro parameter
  • Built-in value such as TIME, DATE, or USER

The comparison operation may compare an expression against a list of explicit literals.

The data types of expression and literal must be compatible. If the data types of the operands differ, Teradata Database performs an implicit conversion from one type to another in some cases.