Functions Overview

{{ocient}} 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\ qmny2tfsokr3y4u6gaxxs aggregate functions docid 72ic0blcf uqzlzeq1 j5 character and binary functions manipulate character strings and binary data types and use character operators to query character data character / binary functions docid\ owrhxf8cezv2io8xd au6 conversion and formatting functions convert data types with scalar conversions and format numbers and times in character outputs scalar data conversion functions docid\ nujw0mginjx8o7schnzrq formatting functions docid\ sckysplqipva5pazgc0w9 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 / time functions docid\ ogk0mhshcuqlakjb6f0nr time zone functions docid\ zto9juk2r5tcf8rge4w 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 72ic0blcf uqzlzeq1 j5 sorted aggregate functions docid\ tsu4axvmvvzzdmkyogrwj window aggregate functions docid\ lnzekaijm5m6ltgz6u2i1 hyperloglog functions docid\ zbvl 3nxtbsgnxvinaufl 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 matrixes array functions and operators docid\ vyvbrjsxibucjxjqvvcad tuple functions and operators docid\ tq8vd4pbhgt3c1 my ym matrix functions and operators docid\ fuwszzewg80 kkiey6 uo geospatial functions functions and operators to manipulate and compare points, linestrings, and polygons geospatial functions docid\ hpngsvdeojhofhdmpyrmh network functions functions for using network data types, including ip and ipv4 network type functions docid\ izaxht5grkbk9mfjh8s6p 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\ vcfvhduqfu2s8vxmkghbc related links sql reference docid\ eaohxmozywvukdfizfpel general sql syntax docid\ ijazgahmd u0x4gsmz8e1