Functions and operators

This section describes the built-in SQL functions and operators supported by Trino. They allow you to implement complex capabilities and behavior of the queries executed by Trino operating on the underlying data sources.

Refer to the following sections for further details:

• SQL data types and other general aspects

• SQL statement and syntax reference

Functions by name

If you are looking for a specific function or operator by name use SHOW FUNCTIONS, or refer to the following resources:

• List of functions and operators
• List of functions by topic

Functions per topic

• Aggregate
• Array
• Binary
• Bitwise
• Color
• Comparison
• Conditional
• Conversion
• Date and time
• Decimal
• Geospatial
• HyperLogLog
• IP Address
• JSON
• Lambda
• Logical
• Machine learning
• Map
• Math
• Quantile digest
• Regular expression
• Session
• Set Digest
• String
• System
• Table
• Teradata
• T-Digest
• URL
• UUID
• Window