Introduction to SQL Functions, Expressions, and Predicates - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

ARRAY/VARRAY functions, operators, expressions, and methods

Teradata Vantage™ - Data Types and Literals, B035-1143

BLOB and CLOB functions

Teradata Vantage™ - Data Types and Literals, B035-1143

Calendar and business calendar functions

Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211

The CAST expression and data type conversion functions

Teradata Vantage™ - Data Types and Literals, B035-1143

Compression/decompression functions Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
DATASET functions and methods Teradata Vantage™ - DATASET Data Type, B035-1198
DateTime and interval functions and expressions

Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211

Export width procedures (manage the amount of data exported to client applications) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
File system information macros and functions (gain information on specific data blocks) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
Geospatial functions and methods Teradata Vantage™ - Geospatial Data Types , B035-1181
JSON functions and methods Teradata Vantage™ - JSON Data Type, B035-1150
Map functions, macros, and procedures (optimize the placement of tables across AMPs) Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
Period functions and operators

Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211

Script installation procedures Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
SET operators (INTERSECT, MINUS/EXCEPT, UNION) Teradata Vantage™ - SQL Data Manipulation Language, B035-1146
Table operators Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210
User-defined type expressions and these UDFs supplied by Teradata:
  • Aggregate
  • Scalar
  • Window aggregate

Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210

XML functions and methods Teradata Vantage™ - XML Data Type, B035-1140