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 docid\ saa2re dvaqcs gtjp3ps docid\ roka1ck6hndmod1smej1s character and binary functions manipulate character strings and binary data types and use character operators to query character data docid\ ja8cont33tonx ktruedj conversion and formatting functions convert data types with scalar conversions and format numbers and times in character outputs docid\ iteimff9ycez0ctcfgqb docid\ naengoslrgk2ikpyh6lkc 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 docid\ hem zd qwquv8dfnvnqz8 docid\ iwtcunl3t9rlghwvu2dsx 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 docid\ roka1ck6hndmod1smej1s docid\ xa9jf8l59tk 4facsfczh docid\ knh6ndwnm hzuab9dwzrz docid\ phb7ceh0zkhenc5beasgb 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 docid\ xuk0z8dmxpgmogszpdw6w docid\ mrrm7nwt xwcg zvmy6 p docid\ nhymyoadealtcppijauc5 geospatial functions functions and operators to manipulate and compare points, linestrings, and polygons docid\ rknitvxzxbrb2w5jfjryo network functions functions for using network data types, including ip and ipv4 docid\ ezupx17nbsz6c4g5e7o o miscellaneous functions a set of functions such as case , current user , and null if that provide additional capabilities in ocient docid\ d5nz44sy24y5 bp ygu7d related links docid\ zvfytm4ip4rwxsa17tvk9 docid\ nw9vavkey2v75moxm muo