SQL Function Reference

These topics provide reference information for the system-defined functions.

Scalar Functions

• Bitwise Expression Functions Perform bitwise operations and manipulations.
• Conditional Expression Functions Implement conditional logic and case statements
• Context Functions Provide information about the current SQL execution context.
• Conversion Functions Convert data types and cast values.
• Date & Time Functions Manipulate and format dates and times.
• Geospatial Functions Handle and manipulate geospatial data.
• Numeric Functions Perform calculations and numeric operations.
• String Functions Manipulate strings and perform regular expression operations.
• Semi-structured and Structured Data Functions Work with JSON and other structured data formats.
• Array Functions Handle and manipulate array data.
• Map Functions Handle and manipulate map data.

Aggregate Functions

• Aggregate Functions Calculate summaries like sum, average, count, etc.
• Window Functions Provide aggregate calculations over a specified range of rows.

Full-Text Search Functions

• Full-Text Search Functions Leverage inverted indexes for efficient data retrieval.

AI Functions

• AI Functions Leverage AI and machine learning capabilities.

Specialized Functions

• Hash Functions Generate hash values for data security and comparison.
• IP Address Functions Manipulate and analyze IP address data.
• UUID Functions Generate and manipulate UUIDs.

System and Table Functions

• System Functions Access system-level information and perform control operations.
• Table Functions Return results in a tabular format.

Other Functions

• Other Miscellaneous Functions A collection of various other functions.