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\ e2c2vckzh8dfsbp1wngpr docid\ qtfpyds4dv4jap2 s6v g character and binary functions manipulate character strings and binary data types and use character operators to query character data docid\ kolkdboplprrwxs3g6gsh conversion and formatting functions convert data types with scalar conversions and format numbers and times in character outputs docid\ bvivszia9qovupkl4waxs docid\ u47hjysi1oojk6eg2kjut 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\ zcon ufstf4uhc5airgpg docid\ ug9cbrhmhijtktyqdhua 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\ qtfpyds4dv4jap2 s6v g docid 6ysvgmcg45ereu6od sxn docid 6wlmm94r86xl pht xkrd docid 9k32fxyxfql49nd7ncwh 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 89kk83 gif3icefcy1kuw docid\ xunz45zvbfsvnbhzy99v5 docid\ dwjpaeks9otz2u sav2lj geospatial functions functions and operators to manipulate and compare points, linestrings, and polygons docid ncku w2ufneog xx3esf network functions functions for using network data types, including ip and ipv4 docid\ bjcnqtthbmpj thiwmdlw miscellaneous functions a set of functions such as case , current user , and null if that provide additional capabilities in ocient docid\ etxli7o estspkhqwbuzf related links docid\ twelobi0rarxjfiot1a70 docid\ qcf0x9ao4a56x id39pkr