Functions

This topic provides reference information for the system-defined functions.

• CAST
  • Syntax
  • Parameters
  • Supported Conversions
    • Numeric Conversions
    • String Conversions
    • Boolean Conversions
    • Array Conversions
  • SQL Standard Compatibility
  • Examples
    • Basic Numeric Conversions
    • String to Numeric Conversion
    • Numeric to String Conversion
    • Boolean Conversions
    • Array Type Conversion
    • Empty Array Casting
    • Null Type Casting
    • Nested Conversions
  • Error Handling
    • Invalid Conversions
    • Range Overflow
• Aggregate Functions
  • List of functions (by sub-category)
    • Standard SQL Aggregates
• Scalar Functions
  • List of functions (by sub-category)
    • Comparison Functions
    • Specialized Functions