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
    • Nested Conversions
  • Error Handling
    • Invalid Conversions
    • Range Overflow
• Aggregate Functions
  • List of functions (by sub-category)
    • BITMAP_CONSTRUCT_AGG
• Scalar Functions
  • List of functions (by sub-category)
    • BITMAP_BIT_POSITION
    • BITMAP_BUCKET_NUMBER
    • BITMAP_BUCKET_OFFSET