Functions Overview

includes many functions for statistics, mathematics, string manipulation, and working with complex types like arrays and geospatial data the following types of functions are supported sql functions math and arithmetic functions perform mathematical operations on data in ocient, including basic operators on data types and advanced statistical functions math functions and operators docid\ fpjn4e63 o7tdrno0sg v aggregate functions docid\ zrac69qenzyasqgj5woq8 character and binary functions manipulate character strings and binary data types and use character operators to query character data character and binary functions docid\ h7i0divmh6cmadxzhsi9j conversion and formatting functions convert data types with scalar conversions and format numbers and times in character outputs scalar data conversion functions docid\ wxb1nwhra9g0lv6uk9lzq formatting functions docid\ aclxyap vc nitdjjoeq date and time functions perform date operations in ocient, including manipulation and comparison of date and time types date and time functions allow users to add, subtract, and truncate date time values and intervals date and time functions docid\ xwimgbnxwbuufgm9fqej1 time zone functions docid\ znicufcjqyby4pvjxular aggregates aggregates include basic aggregates and sorted aggregates that combine many rows into a single result, as well as window aggregates that combine information from multiple rows within the window into each row in the result set aggregate functions docid\ zrac69qenzyasqgj5woq8 window aggregate functions docid\ yil5g89brwhxuqbmawiar hyperloglog functions docid 45odcf u70i5s7ngbz9gn array, tuple, and matrix functions special functions and operators to work with container types these include operators to check set logic, slice, compare, and manipulate arrays, tuples, and matrices array functions and operators docid\ imlc3bk23fgefieyv 0mg tuple functions and operators docid\ y8bea6 vwd6ud6qtudoes matrix functions and operators docid\ iq4wlrmjge4avqvi0c 8 geospatial functions functions and operators to manipulate and compare points, linestrings, and polygons geospatial functions docid\ c xku2wubvnuz7vck rnl network functions functions for using network data types, including ip and ipv4 network type functions docid 8rp8mbilrxtnc grswdmf miscellaneous functions a set of functions such as case , current user , and null if that provide additional capabilities in ocient other functions and expressions docid\ sf23apami4vwhed bpem related links sql reference docid\ ntdu6jmn5tj143igbgvh general sql syntax docid\ jgnyaywtjqwrpigkg uvk