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.
This document describes common SQL functions, expressions, and predicates that SQL application programmers can use.
Additional functions that are documented in other books are listed in the following table.
| 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:
|
Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210 |
| XML functions and methods | Teradata Vantage™ XML Data Type, B035-1140 |