Functions reference

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

• Aggregate functions: functions that take multiple rows/values as input and return a single value.
• Scalar functions: functions that take a single value as input and return a single value.
  • Conditional expression functions
  • Conversion functions
  • Date and time functions
  • Numeric functions
  • String functions
  • Semi-structured data functions