Alphabetical SQL Functions List

function name category name function description https //docs ocient com/math functions and operators#81xj5 math functions returns the absolute value of a specified floating point number https //docs ocient com/matrix functions and operators matrix functions returns magnitude of one dimensional matrix/vector https //docs ocient com/math functions and operators#junsx math functions returns the inverse cosine of a specified floating point number https //docs ocient com/math functions and operators#ioc0p math functions returns the hyperbolic arc cosine of a specified floating point number https //docs ocient com/date and time functions#oii n date and time functions adds the specified number of months to the date https //docs ocient com/aggregate functions aggregate functions returns an arbitrary, non null value from the input column https //docs ocient com/aggregate functions aggregate functions approximate distinct count by using hyper log log (95% confidence interval that the value is within 4 5%) docid\ a794p1hruev25euof9svc aggregate functions allows the aggregation engine to use a faster, non deterministic ordering to summate floating point columns https //docs ocient com/array functions and operators array functions postgresql® compliant constructor the type of the array is deduced from the elements https //docs ocient com/sorted aggregate functions sorted aggregate functions returns an array containing every row from the expression https //docs ocient com/array functions and operators array functions add value to the back of an array https //docs ocient com/array functions and operators array functions returns the corresponding argmax of the array as a bigint index https //docs ocient com/array functions and operators array functions returns the corresponding argmin of the array as a bigint index https //docs ocient com/array functions and operators array functions concatenate 2 arrays into a new one https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions restrict the length of an array to a maximum number of elements https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions removes null values from the array https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions returns true if the array contains the specified value https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions return all unique values in an array https //docs ocient com/array functions and operators array functions return the number of elements of a given array https //docs ocient com/array functions and operators array functions returns the corresponding maximum of the array https //docs ocient com/array functions and operators array functions returns the corresponding minimum of the array https //docs ocient com/array functions and operators array functions returns the position of the first matching scalar in the array https //docs ocient com/array functions and operators array functions returns all elements stored in the right array and returns their respective positions in the left array https //docs ocient com/array functions and operators array functions add value to the front of an array https //docs ocient com/array functions and operators array functions remove value from the array https //docs ocient com/array functions and operators array functions replace value by another in an array https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions sort and return the input array based on the natural ordering of its elements or the specified lambda function https //docs ocient com/array functions and operators array functions returns the sum of the array the array must be one dimensional and contain numeric values null values do not contribute to the sum https //docs ocient com/array functions and operators array functions converts array to a list of elements separated by 'delimiter' https //docs ocient com/character and binary functions#eaw i character and binary functions returns the ascii code value of the leftmost character of the character value https //docs ocient com/math functions and operators#n0xut math functions returns the inverse sine of a specified floating point number https //docs ocient com/math functions and operators#ymojg math functions returns the hyperbolic arc sine of a specified floating point number https //docs ocient com/math functions and operators#mgtmy math functions returns the inverse tangent of a specified floating point number https //docs ocient com/math functions and operators#t6vzw math functions returns the inverse tangent of two numeric, floating point values https //docs ocient com/math functions and operators#8uybq math functions returns the hyperbolic arc tangent of a specified floating point number https //docs ocient com/aggregate functions aggregate functions average, or arithmetic mean, over the set https //docs ocient com/math functions and operators#wffuo math functions the cumulative distribution function of the standard bivariate normal distribution https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type bigint https //docs ocient com/scalar data conversion functions scalar data conversion functions parses a hexadecimal string (such as 0x54ab) to create a binary value letters can be of either case https //docs ocient com/math functions and operators#e2jo6 math functions the probability density function of the standard bivariate normal distribution https //docs ocient com/character and binary functions#niwnr character and binary functions returns the length of the character value in bits https //docs ocient com/math functions and operators#ancrp math functions alias for the bitfunc syntax bitfunc('and', x, y) https //docs ocient com/math functions and operators#zi1nv math functions performs a variety of bit operations can be any of these string literals 'and' , 'or' , or 'xor' https //docs ocient com/math functions and operators#fzlqt math functions returns the bitwise negation of integral x https //docs ocient com/math functions and operators# iimb math functions alias for the bitfunc syntax bitfunc('or', x, y) https //docs ocient com/math functions and operators#gsh5s math functions alias for the bitfunc syntax bitfunc('xor', x, y) https //docs ocient com/math functions and operators# ndel math functions alias for the boolfunc syntax boolfunc('and', x, y) https //docs ocient com/scalar data conversion functions scalar data conversion functions parses a string to create a boolean value the string must contain either true or false it is case insensitive https //docs ocient com/math functions and operators#uktjx math functions performs a boolean logical evaluation on arguments x and y can be any of these string literals 'and' , 'or' , or 'xor' https //docs ocient com/math functions and operators#a2ksi math functions returns the logical negation of the boolfunc function https //docs ocient com/math functions and operators#uayrm math functions alias for the boolfunc syntax boolfunc('or', x, y) https //docs ocient com/math functions and operators#ykq4j math functions alias for the boolfunc syntax boolfunc('xor', x, y) https //docs ocient com/character and binary functions#9dy9g character and binary functions alias for trim https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type byte https //docs ocient com/other functions and expressions#xqx3s conditional functions case operates similarly to conditional scripting in other programming languages, allowing it to function like an if / then / else statement or as a switch statement https //docs ocient com/transform data in data pipelines#x eux special data pipeline transformation functions returns the result value based on whether an expression is true https //docs ocient com/array functions and operators array functions casts the elements of the array to another type https //docs ocient com/tuple functions and operators#ii1hv tuple functions converts a tuple into another tuple of a different type https //docs ocient com/math functions and operators#yiewv math functions returns the cube root of the numeric value x https //docs ocient com/math functions and operators#62kpm math functions the cumulative distribution function of the standard normal distribution returns the probability that a random sample is less than or equal to the specified value https //docs ocient com/math functions and operators#xtoze math functions returns the nearest integer greater than or equal to x https //docs ocient com/math functions and operators#p4t0q math functions alias for ceil https //docs ocient com/date and time functions# 0cdv date and time functions returns the number of centuries https //docs ocient com/array functions and operators array functions converts array to its string representation https //docs ocient com/scalar data conversion functions scalar data conversion functions creates a string version of the numeric value https //docs ocient com/tuple functions and operators#ii1hv tuple functions converts a tuple to its string representation https //docs ocient com/character and binary functions#wn8xq character and binary functions alias for length https //docs ocient com/character and binary functions#7xlw character and binary functions alias for length https //docs ocient com/character and binary functions#jeht7 character and binary functions converts an integer value to a string https //docs ocient com/other functions and expressions# twvc conditional functions evaluates to the first argument that is not null, or null if all arguments are null https //docs ocient com/other functions and expressions#ophfv system functions returns the most recent commit hash of the database to which the client is currently connected https //docs ocient com/character and binary functions#9tr8c character and binary functions concatenates two values, which must both be either binary, hash, or string data types this function is equivalent to the || operator https //docs ocient com/time zone functions#i6hdn time zone functions the function converts a timestamp in a specified local time zone to the utc time zone https //docs ocient com/time zone functions#eue6i time zone functions the function converts a timestamp from the utc time zone to a specified local time zone https //docs ocient com/aggregate functions aggregate functions alias for correlation https //docs ocient com/aggregate functions aggregate functions sample correlation https //docs ocient com/aggregate functions aggregate functions population correlation https //docs ocient com/math functions and operators#xlkbe math functions returns the cosine of x https //docs ocient com/math functions and operators#74yqi math functions returns the hyperbolic cosine of x https //docs ocient com/math functions and operators#lvtj6 math functions returns the cotangent of x https //docs ocient com/aggregate functions aggregate functions number of rows in the set https //docs ocient com/aggregate functions aggregate functions alias for covariancep https //docs ocient com/aggregate functions aggregate functions alias for covariance https //docs ocient com/aggregate functions aggregate functions sample covariance https //docs ocient com/aggregate functions aggregate functions population covariance https //docs ocient com/array functions and operators array functions returns the cross entropy loss of two arrays https //docs ocient com/matrix functions and operators matrix functions returns the cross entropy loss of two one dimensional matrixes or vectors https //docs ocient com/window aggregate functions#ttnh4 window aggregate functions returns a number 0 < n 1 and can be used to calculate the percentage of values less than or equal to the current value in the group https //docs ocient com/date and time functions#g8kn7 date and time functions alias for current date https //docs ocient com/other functions and expressions#xiqyl system functions alias for database https //docs ocient com/date and time functions# 7lyn date and time functions returns the current date in the format yyyy mm dd https //docs ocient com/other functions and expressions#nmz92 system functions returns the name of the sql node where the current query executes the name of the node corresponds to the name column in the sys nodes system catalog table https //docs ocient com/other functions and expressions#lo34i system functions returns the identifier of the sql node where the current query executes https //docs ocient com/other functions and expressions#nk7km system functions returns the name of the current schema https //docs ocient com/other functions and expressions#dxe8v system functions returns the name of the system https //docs ocient com/date and time functions#ezfn0 date and time functions returns the current date and time as a timestamp value (e g , yyyy mm dd hh🇲🇲ss mmm) https //docs ocient com/other functions and expressions#uuzm2 system functions returns the user for the current connection https //docs ocient com/other functions and expressions#ckuy8 system functions returns the name of the database to which the client is currently connected https //docs ocient com/scalar data conversion functions scalar data conversion functions parses a string in the form 'yyyy mm dd' to create a date extra characters are ignored https //docs ocient com/date and time functions#ez2cl date and time functions alias for extract https //docs ocient com/date and time functions#pdylp date and time functions returns the date or timestamp entered, truncated to the specified precision https //docs ocient com/date and time functions#fcqyr date and time functions adds a specified number value (as a signed integer) to a specified date part of an input date value, and then returns that modified value https //docs ocient com/date and time functions#rpffa date and time functions this function returns an int representing the difference between two date or time values in a specified date or time unit https //docs ocient com/date and time functions# qyqw date and time functions alias for day of month https //docs ocient com/date and time functions#iz i5 date and time functions extracts the day of month portion of a timestamp or date as an integer https //docs ocient com/date and time functions#elj49 date and time functions returns an integer, in the range of 1 to 7, that represents the day of the week https //docs ocient com/date and time functions#zqbwr date and time functions returns an integer in the range 1 to 366 that represents the day of the year https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type days to be used in date calculations https //docs ocient com/date and time functions#u0dqm date and time functions the decade is the year divided by 10 https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type decimal https //docs ocient com/math functions and operators#ldgtm math functions returns the corresponding angle in degrees for x in radians https //docs ocient com/window aggregate functions#uox69 window aggregate functions computes the finite difference between successive values of expression under the specified ordering this is a backwards difference, which means that, at degree one, the value for a given row is the difference between the value of expression for that row and the previous row https //docs ocient com/window aggregate functions#qm dn window aggregate functions assigns a number to each row in the result set with equal values having the same number there will be no gaps between ranks https //docs ocient com/window aggregate functions#aaz8y window aggregate functions computes the difference quotient between successive values of expression with respect to expression2 https //docs ocient com/matrix functions and operators matrix functions returns the determinant of the matrix as a double https //docs ocient com/math functions and operators#6tq8z math functions returns the result of x divided by y if y is zero, returns null https //docs ocient com/matrix functions and operators matrix functions returns dot product of two one dimensional matrixes/vectors https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type double https //docs ocient com/date and time functions#ndy0j date and time functions alias for day of week https //docs ocient com/date and time functions#ntkkz date and time functions alias for day of year https //docs ocient com/matrix functions and operators matrix functions returns eigenvalues and eigenvalues of a square matrix as a vector of pairs https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions returns the element value of the array or tuple at the specified index https //docs ocient com/character and binary functions#xhnlf character and binary functions returns true if x ends with y and false otherwise https //docs ocient com/date and time functions#ydmhm date and time functions returns the last day of the timestamp or date https //docs ocient com/date and time functions#tokib date and time functions the number of seconds after 1970 01 01 00 00 00 utc https //docs ocient com/math functions and operators#nt93f math functions the error function is used for measurements that follow a normal distribution https //docs ocient com/math functions and operators#ckbfz math functions the complement of the error function erfc(x) = 1 erf(x) https //docs ocient com/math functions and operators#djzby math functions returns the exponential of x (e raised to the power of x) https //docs ocient com/special data pipeline transformation functions#mv3 n special data pipeline transformation functions expands a one dimensional or multidimensional array into its elements with one element per row of output from the system https //docs ocient com/date and time functions#mh7gr date and time functions extract a component from a timestamp or date https //docs ocient com/special data pipeline transformation functions#liutw special data pipeline transformation functions filters elements in an array based on the logic in a lambda expression https //docs ocient com/window aggregate functions#8mjzl window aggregate functions returns the first value in the ordered result set https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions transforms an n dimensional array into an n 1 dimensional array https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type float https //docs ocient com/math functions and operators#m8ugb math functions returns the nearest integer less than or equal to x https //docs ocient com/matrix functions and operators matrix functions and operators returns the frobenius norm of a matrix https //docs ocient com/math functions and operators#iefyy math functions https //en wikipedia org/wiki/gamma function https //docs ocient com/other functions and expressions#httsy conditional functions returns the largest non null value of all the arguments, or null if all the arguments are null https //docs ocient com/scalar data conversion functions scalar data conversion functions creates a fixed length binary value, with length \<length> , from a string, i e 0x1234abcd zero extended if the string does not have enough bytes, truncated if it has too many https //docs ocient com/math functions and operators#xdhi math functions returns the x coordinate of the center of the nearest hexagonal bin to the point (x, y) https //docs ocient com/math functions and operators#mvl50 math functions returns the y coordinate of the center of the nearest hexagonal bin to the point (x, y) https //docs ocient com/array functions and operators array functions returns the hinge loss of two arrays https //docs ocient com/matrix functions and operators matrix functions returns the hinge loss of two one dimensional matrixes or vectors https //docs ocient com/hyperloglog functions#ca6io hyperloglog functions creates an hll sketch from the data on a specified aggregated column returns a hash((2^log2k) + 8) data representation of the sketch that you can store in a separate column https //docs ocient com/hyperloglog functions#kulae hyperloglog functions the scalar function converts a sketch into a distinct count estimate of a sketch value returns the distinct count estimate as a bigint https //docs ocient com/hyperloglog functions#m0o46 hyperloglog functions takes a hll sketch column or an integral log2k literal value and returns the resulting bounding 95 percent confidence interval error proportion as a double https //docs ocient com/hyperloglog functions# m71a hyperloglog functions the hll sketch to string scalar function takes a hll sketch column or value and returns a string summary of the sketch https //docs ocient com/hyperloglog functions#kyvht hyperloglog functions merges multiple sketches in a single column into a unified sketch all sketches must have the same precision this function is an aggregate function and operates on a column https //docs ocient com/hyperloglog functions#ht0cw hyperloglog functions merges two sketches into a new combined sketch this function is a scalar function and operates row wise the scalar function merges two sketch columns with heterogeneous precisions into a sketch with the lower of the two precisions https //docs ocient com/date and time functions#6yqot date and time functions extracts the hour portion of a timestamp as an integer https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type hours https //docs ocient com/matrix functions and operators matrix functions returns an identity matrix of the specified dimension https //docs ocient com/math functions and operators#nng a math functions the inverse of the erf error function https //docs ocient com/math functions and operators#lgkj6 math functions the inverse of the complement of the error function https //docs ocient com/transform data in data pipelines#x eux special data pipeline transformation functions returns t if the expression x evaluates to true , or the function returns f if x evaluates to false https //docs ocient com/other functions and expressions#wrqbz conditional functions alias for coalesce https //docs ocient com/character and binary functions#9krod character and binary functions for each word in the provided string, capitalize the first character if it is alphabetic https //docs ocient com/character and binary functions#mjw1m character and binary functions returns the index position of the first occurrence where the character value char substring appears in the character value char by ignoring case https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type integer https //docs ocient com/matrix functions and operators matrix functions returns inverse of a square, invertible matrix https //docs ocient com/network type functions#yssyu network type functions casts an ip data type from an ipv4 data type expression https //docs ocient com/network type functions#ygasp network type functions casts an ipv4 address from an ipv6 address https //docs ocient com/date and time functions#ono x date and time functions returns true if the input argument can be successfully cast to a date https //docs ocient com/network type functions#3iklc network type functions t ests whether the database can convert the ip value to the ipv4 data type https //docs ocient com/date and time functions#ccyhv date and time functions extracts the day of the week based on iso 8601, which ranges from monday (1) to sunday (7) https //docs ocient com/character and binary functions#ht6bq character and binary functions returns the value for the key value pair referenced by a series of path elements in a json string https //docs ocient com/aggregate functions aggregate functions the sample over the set https //docs ocient com/aggregate functions aggregate functions the population over the set https //docs ocient com/window aggregate functions#ooaer window aggregate functions returns the row which is the specified number backward from the current row default is 1 if offset is omitted https //docs ocient com/window aggregate functions# 3jqe window aggregate functions returns the last value in the ordered result set https //docs ocient com/character and binary functions#zmum character and binary functions alias for lower https //docs ocient com/window aggregate functions#dvmj6 window aggregate functions returns the row which is the specified number forward from the current row default is 1 if offset is omitted https //docs ocient com/math functions and operators#dbq2o math functions returns the leaky rectified linear unit function of x https //docs ocient com/other functions and expressions#2vczg conditional functions returns the smallest non null value of all arguments, or null if all arguments are null https //docs ocient com/character and binary functions#clz1b character and binary functions return the number of characters in the string equal to the value integer if the integer is negative, the function returns all but the last integer characters https //docs ocient com/math functions and operators#v55 4 math functions returns x shifted to the left by y bits https //docs ocient com/character and binary functions#spvjs character and binary functions for character data types, this value is in terms of characters for binary data types, this value is in terms of bytes https //docs ocient com/math functions and operators#cyijm math functions returns the natural logarithm of x https //docs ocient com/character and binary functions# 4mhu character and binary functions alias for position returns the index position of the first occurrence of the character value substring in the character value string https //docs ocient com/math functions and operators#efvuc math functions returns the base 10 logarithm of x the optional base argument specifies the numeral system to use if unspecified, the function defaults to base 10 https //docs ocient com/math functions and operators#5e7oq math functions the natural logarithm of the absolute value of the gamma function https //docs ocient com/array functions and operators array functions returns the log loss of two arrays https //docs ocient com/matrix functions and operators matrix functions returns the log loss of two one dimensional matrixes or vectors https //docs ocient com/math functions and operators#eonbt math functions returns the base 2 logarithm of x https //docs ocient com/array functions and operators array functions returns the logits loss of two arrays https //docs ocient com/matrix functions and operators matrix functions returns the logits loss of two one dimensional matrixes or vectors https //docs ocient com/character and binary functions#visby character and binary functions alias for lcase convert string to lowercase https //docs ocient com/character and binary functions# jq0h character and binary functions pad the input text to the specified length with the pad string on the left side https //docs ocient com/character and binary functions#7tfyj character and binary functions removes leading blanks from the string value string https //docs ocient com/matrix functions and operators matrix functions returns lupq decomposition of a square matrix a as a tuple of 4 matrixes where paq = lu https //docs ocient com/transform data in data pipelines#xw5f4 special data pipeline transformation functions returns the keys in the specified json string https //docs ocient com/transform data in data pipelines#xw5f4 special data pipeline transformation functions returns the values in the specified json string https //docs ocient com/matrix functions and operators#ggbhi matrix functions returns the dimensions of the specified matrix as a tuple of (row, col) integers https //docs ocient com/matrix functions and operators#ggbhi matrix functions creates an ixj matrix with elements e 00 , … , e ij https //docs ocient com/date and time functions#1ilhp date and time functions returns a timestamp consisting of the specified date and time https //docs ocient com/matrix functions and operators matrix functions creates a matrix from the specified string https //docs ocient com/matrix functions and operators matrix functions returns trace of a square matrix as a double https //docs ocient com/aggregate functions aggregate functions maximum value in the specified column https //docs ocient com/character and binary functions#bfgh9 character and binary functions returns the hexadecimal string (all lowercase) representing the md5 hash of char https //docs ocient com/transform data in data pipelines#tgsmc special data pipeline transformation functions extracts the metadata value for the specified key from available metadata for the pipeline https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type microseconds https //docs ocient com/character and binary functions#pbbau character and binary functions alias for substring https //docs ocient com/date and time functions#wcjdl date and time functions extracts the millisecond portion of a timestamp as an integer https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type milliseconds https //docs ocient com/aggregate functions aggregate functions minimum value in the specified column https //docs ocient com/date and time functions#ufpkj date and time functions extracts the minute portion of a timestamp or date as an integer https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type minutes https //docs ocient com/math functions and operators#rndr math functions returns the remainder from x divided by y https //docs ocient com/date and time functions# wdh0 date and time functions extracts the month portion of a timestamp or date as an integer https //docs ocient com/date and time functions#b5lba date and time functions returns the calendar name in english of the month for the specified date https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type months to be used in date calculations https //docs ocient com/date and time functions#gflzd date and time functions returns the difference between the two dates or timestamps in months as a double https //docs ocient com/date and time functions#ryi1 date and time functions the seconds field, including fractional parts the function multiplies the seconds part of the value by 1,000 https //docs ocient com/other functions and expressions#lhd1w conditional functions https //github com/aappleby/smhasher/blob/master/readme md https //docs ocient com/date and time functions#qvdh6 date and time functions convert a number of nanoseconds into a timestamp equivalent to the duration after the epoch time https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type nanoseconds https //docs ocient com/date and time functions#vzlbd date and time functions returns the closest date after a specified date that lies on a specific day of the week https //docs ocient com/date and time functions#zzhsq date and time functions alias for current timestamp https //docs ocient com/window aggregate functions#ctylw window aggregate functions returns the nth value in the ordered result set https //docs ocient com/other functions and expressions#wzyfr conditional functions returns the null value if two arguments are equal; otherwise, returns the first argument https //docs ocient com/matrix functions and operators matrix functions returns a null matrix of the given (row, col) dimensions https //docs ocient com/character and binary functions#gpl4a character and binary functions returns the length in bytes of a character or binary value https //docs ocient com/transform data in data pipelines#tgsmc special data pipeline transformation functions converts a string of text data representing an array into a char\[] https //docs ocient com/window aggregate functions#a2vai window aggregate functions the value returned is 0 < n ≤ 1 and can be used to calculate the percentage of values less than the current group, excluding the highest value https //docs ocient com/window aggregate functions#fphge window aggregate functions returns the value that corresponds to the specified percentile (0 ≤ n ≤ 1) within the group https //docs ocient com/math functions and operators#uufx math functions returns the constant value of π https //docs ocient com/math functions and operators#1wvow math functions returns the smallest non negative equivalence class of x % y https //docs ocient com/character and binary functions#j28jb character and binary functions alias for locate https //docs ocient com/math functions and operators#d5tj4 math functions returns x raised to the power of y https //docs ocient com/math functions and operators#p7lbt math functions the inverse of the cumulative distribution function https //docs ocient com/aggregate functions aggregate functions product over the set https //docs ocient com/matrix functions and operators matrix functions returns qr decomposition of a matrix as a tuple of 2 matrixes https //docs ocient com/date and time functions#mp7 1 date and time functions returns an integer between 1 and 4 that represents the quarter of the year in which the specified date falls https //docs ocient com/math functions and operators#vu7bi math functions returns the corresponding angle in radians for x in degrees https //docs ocient com/math functions and operators#j3jjt math functions takes no argument and returns a random double value in the range \[0, 1) https //docs ocient com/window aggregate functions#ido8v window aggregate functions assigns a number to each row in the result set with equal values having the same number there can be gaps between ranks https //docs ocient com/window aggregate functions#hyx0c window aggregate functions computes the ratio of a value to the sum of the set of values https //docs ocient com/lat transformation functions other transformation functions returns string that represents a unique identifier for the record in a given pipeline for a given file group or topic https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions applies a merge function to a starting value and all elements in the array, and then reduces the array to a single value optionally, specify a finish function for the returned single value https //docs ocient com/character and binary functions#6bfif character and binary functions searches a string for all occurrences of a regular expression pattern https //docs ocient com/character and binary functions#bx1sw character and binary functions searches a string using a regular expression pattern and returns an integer representing the start position or end position of the substring that matches https //docs ocient com/character and binary functions#usppl character and binary functions searches a string for all occurrences of a regular expression pattern https //docs ocient com/character and binary functions#z x9p character and binary functions returns one substring from a string that matches a specified regular expression pattern https //docs ocient com/math functions and operators#pcyvj math functions returns the rectified linear unit function of x https //docs ocient com/character and binary functions#6bfif character and binary functions repeats the character value char a number of times equal to num https //docs ocient com/character and binary functions#0fqd character and binary functions replaces all occurrences of substr to remove in the character value string with substr to replace https //docs ocient com/character and binary functions#582yz character and binary functions reverse the input string https //docs ocient com/character and binary functions#vgdfk character and binary functions return the number of trailing characters in the string equal to the value integer https //docs ocient com/math functions and operators#a3c4x math functions returns x shifted to the right by y bits https //docs ocient com/date and time functions#jayo1 date and time functions returns the specified date or timestamp, rounded to the specified precision https //docs ocient com/math functions and operators#kch1q math functions returns x rounded to the nearest integer https //docs ocient com/window aggregate functions#rdl6i window aggregate functions assigns a unique number to each row in the result set https //docs ocient com/character and binary functions#raxqa character and binary functions pad the input text to the specified length with the pad string on the right side https //docs ocient com/character and binary functions#mq8en character and binary functions returns the substring from the right side of a string, based on a specified length https //docs ocient com/character and binary functions#8djr6 character and binary functions removes leading blanks from the string value string https //docs ocient com/date and time functions#nnjmm date and time functions extracts the seconds portion of a timestamp as an integer https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type seconds https //docs ocient com/character and binary functions#sgl o character and binary functions uses the https //en wikipedia org/wiki/sha 1# text=in%20cryptography%2c%20sha%2d1%20(,rendered%20as%2040%20hexadecimal%20digits cryptographic hash function to convert a string into a 40 character string representing the hexadecimal value of a 160 bit checksum https //docs ocient com/other functions and expressions#dl vh system functions the show function enables you to explore the database and its metadata for user defined items https //docs ocient com/math functions and operators#i8hpi math functions returns the positive (+1), zero (0), or negative ( 1) sign of x https //docs ocient com/math functions and operators#v zfo math functions returns the sine of x https //docs ocient com/math functions and operators#i c18 math functions returns the hyperbolic sine of x https //docs ocient com/aggregate functions aggregate functions the sample over the set https //docs ocient com/scalar data conversion functions scalar data conversion functions casts the argument to a value of type smallint https //docs ocient com/array functions and operators array functions returns the softmax of the array https //docs ocient com/matrix functions and operators matrix functions returns the softmax of a one dimensional matrix or vector https //docs ocient com/character and binary functions#e1eyc character and binary functions returns a string of repeated spaces equal to the number value, repeat https //docs ocient com/character and binary functions#0mwny character and binary functions split the value string based on the delimiter value the function returns a substring from the split operation based on the index value (starting from 1) https //docs ocient com/character and binary functions# a4om character and binary functions splits a string into an array of substrings https //docs ocient com/math functions and operators#m5azx math functions returns the square root of x https //docs ocient com/math functions and operators#xdty2 math functions returns the square of x https //docs ocient com/linestring functions#foii0 geospatial linestring constructor adds a point to the given linestring at the specified 0 indexed location https //docs ocient com/spatial measurement#yfbjl geospatial spatial measurement calculates the angle between two lines https //docs ocient com/spatial measurement#odfpu geospatial spatial measurement returns the area of the specified geospatial object in the specified unit of measurement https //docs ocient com/conversion functions#ldhmh geospatial conversion functions returns the well known binary (wkb) representation of the specified geography alias of st aswkb https //docs ocient com/conversion functions#tgipx geospatial conversion functions returns a string that represents geographic coordinates of a specified point in the specified format https //docs ocient com/conversion functions#vycvv geospatial conversion functions alias of st asbinary https //docs ocient com/conversion functions#u1q s geospatial conversion functions https //datatracker ietf org/doc/html/rfc7946 https //docs ocient com/conversion functions#hgl1x geospatial conversion functions alias of st astext https //docs ocient com/conversion functions#v kkz geospatial conversion functions alias of st astext https //docs ocient com/conversion functions#f0nxy geospatial conversion functions alias of st aswkt and st ewkt returns the wkt representation of the specified geography https //docs ocient com/spatial measurement#g1s g geospatial spatial measurement returns the azimuth of the line from point1 to point2 in radians https //docs ocient com/spatial operators#wcgia geospatial spatial operators returns the diagonal linestring from the minimum point to the maximum point of the bounding box that st envelope returns https //docs ocient com/spatial operators#ecru geospatial spatial operators returns a geography that contains all points where the distance from the geography is less than or equal to the specified distance https //docs ocient com/point constructors#hxhyf geospatial point constructors the geographic center of mass is calculated by taking the average of all points on a three dimensional sphere, projecting the resultant point onto the sphere, and converting it back to latitude and longitude coordinates https //docs ocient com/spatial operators#qwvfh geospatial spatial operators returns the two dimensional point of one specified geospatial object that is closest to a second specified geospatial object https //docs ocient com/spatial relationships#yrsp2 geospatial spatial relationships https //en wikipedia org/wiki/dbscan https //docs ocient com/spatial relationships#pkyhf geospatial spatial relationships returns true if the first geographic argument, geo1, contains the second geographic argument, geo2 https //docs ocient com/spatial relationships#ed7pc geospatial spatial relationships returns true if geo2 lies entirely in the interior of geo1, and does not intersect or touch the boundary or exterior points https //docs ocient com/spatial operators#ptnel geospatial spatial operators the convex hull is the smallest convex geometry that encloses the input geometry https //docs ocient com/attribute functions#8civl geospatial attribute functions alias for st ndims or st ndimension returns an integer of the coordinate dimension of the specified geography https //docs ocient com/spatial relationships#rr dn geospatial spatial relationships returns true if no point in geo1 is outside of geo2 https //docs ocient com/spatial relationships#tcwrq geospatial spatial relationships returns true if no point in geo2 is outside of geo1 https //docs ocient com/spatial relationships#vnt7y geospatial spatial relationships returns true if two geospatial objects meet these criteria the intersection of the geospatial interiors is not empty the intersection is not equal to geo1 or geo2 neither geospatial object is a single point https //docs ocient com/spatial operators#scdcb geospatial spatial operators returns an array containing any geospatial objects that are present in the first specified geospatial argument that are not found in the second geospatial argument https //docs ocient com/attribute functions#edwwv geospatial attribute functions returns an integer that represents the dimension of the specified geography https //docs ocient com/spatial relationships# 2yqz geospatial spatial relationships returns true if the specified geographies have no intersection, including boundaries both geographic arguments can be different types https //docs ocient com/spatial measurement#frzqn geospatial spatial measurement returns the minimum distance between the specified arguments https //docs ocient com/spatiotemporal measurement#mbv7i geospatial spatiotemporal measu returns the two dimensional interpolated minimum simultaneous distance between two linestring timestamp array pairs in the specified unit of measurement https //docs ocient com/spatial measurement#3jwfn geospatial spatial measurement returns the minimum distance between the specified arguments using a spherical computation https //docs ocient com/spatial measurement#9zrgm geospatial spatial measurement returns the minimum distance between the specified arguments using a spheroid computation https //docs ocient com/spatial relationships#wfmma geospatial spatial relationships returns true if the geographies are within a specified distance in meters https //docs ocient com/linestring functions#dh3ly geospatial linestring constructor returns the endpoint of a specified linestring the returned value is a point https //docs ocient com/spatial operators#wkicv geospatial spatial operators returns a polygon that represents the minimum bounding box for the specified geography https //docs ocient com/spatial relationships#n4bni geospatial spatial relationships returns true if both geographies are spatially equal https //docs ocient com/spatial measurement#hervh geospatial spatial measurement returns the minimum distance between two geospatial points with altitude values https //docs ocient com/spatial operators#bgwcw geospatial spatial operators returns the bounding box of a specified geospatial value, which is expanded by a specified length https //docs ocient com/spatial operators#uxqis geospatial spatial operators returns a linestring that represents the exterior ring of a provided polygon value https //docs ocient com/spatial operators#ekvrp geospatial spatial operators returns a new geographic object with the x and y coordinates switched using the specified argument https //docs ocient com/spatial operators#l7yes geospatial spatial operators convert a geographic object into a two dimensional geography https //docs ocient com/polygon constructors#l7 qg geospatial polygon constructors creates a standardized polygon from an existing one ocient® defines standardized as the exterior being counterclockwise (ccw) and all holes being clockwise (cw) oriented https //docs ocient com/point constructors#oah1p geospatial point constructors creates and returns a polygon geography with a single point, defined by the longitude and latitude specified for the function https //docs ocient com/conversion functions#q58iy geospatial conversion functions returns a string that represents the geohash of the input point https //docs ocient com/attribute functions#b9qc4 geospatial attribute functions returns a string representing the geometry type of the input value https //docs ocient com/spatial measurement#p c1k geospatial spatial measurement returns the hausdorff distance between two geographies in a specified measurement https //docs ocient com/spatial operators#s7zkd geospatial spatial operators returns a linestring representing the interior ring of the specified polygon, which is specified by its index (1 indexed) https //docs ocient com/spatial operators#ymwul geospatial spatial operators returns the intersection of all geographies in the specified array all geographies in the array must be the same type https //docs ocient com/spatiotemporal operators#b1d7d geospatial spatiotemporal measu returns a tuple that represents the intersection of a spatiotemporal linestring with a static geography https //docs ocient com/spatial operators#8jwir geospatial spatial operators returns a geography that represents the point set intersection of two geographies https //docs ocient com/spatial relationships#ss1la geospatial spatial relationships returns true if the specified geographies have an intersection, including boundaries https //docs ocient com/spatial relationships#syr0i geospatial spatial relationships alias for st ispolygonccw https //docs ocient com/spatial relationships#vxfkx geospatial spatial relationships returns true if an input polygon has an exterior that is counter clockwise https //docs ocient com/attribute functions#zb 0v geospatial attribute functions returns true if the specified geography value is empty, such as 'polygon empty' https //docs ocient com/spatial relationships#k3i4m geospatial spatial relationships returns true if an input linestring has starting and ending points that are equal https //docs ocient com/spatial relationships#nby 1 geospatial spatial relationships returns true if an input polygon has an exterior that is clockwise https //docs ocient com/spatial relationships#8jbbm geospatial spatial relationships returns true if the specified linestring is closed and does not intersect itself https //docs ocient com/spatial relationships#udejb geospatial spatial relationships for linestring values, this function returns false if any line segments intersect anywhere besides the endpoints for polygon values, the function returns false if either the exterior ring or any interior hole is not simple https //docs ocient com/spatial relationships#yfeph geospatial spatial relationships https //www ogc org/standard/sfa/ https //docs ocient com/spatial measurement#jpgoz geospatial spatial measurement returns the length of the specified line in the specified measurement unit https //docs ocient com/spatial measurement#ihut geospatial spatial measurement alias for st length https //docs ocient com/linestring constructors#x9idi geospatial linestring constructor creates a linestring from the specified char https //docs ocient com/linestring constructors#qdq7r geospatial linestring constructor creates a linestring represented by the specified geojson https //docs ocient com/linestring constructors#iar3u geospatial linestring constructor creates a linestring from a specified char the char must be a linestring value in wkt format https //docs ocient com/linestring constructors#q1l 4 geospatial linestring constructor creates a linestring from the specified binary the binary value must be a linestring in wkb format https //docs ocient com/spatiotemporal operators#pshgp geospatial spatiotemporal measu returns a timestamp array of all times when the specified linestring value intersects the specified point value https //docs ocient com/spatiotemporal operators#k17o7 geospatial spatiotemporal measu returns a point within the bounds of the specified linestring that corresponds to the interpolated point at the specified timestamp value https //docs ocient com/spatiotemporal operators#jzmk geospatial spatiotemporal measu returns the interpolated time of the specified point on the specified linestring that is paired with a timestamp array https //docs ocient com/linestring functions#x wa geospatial linestring constructor returns a point along a linestring based on a specified fraction of its total length https //docs ocient com/linestring functions#d2y0h geospatial linestring constructor similar to st lineinterpolatepoint, this function computes a fraction based on where a specified point is located along the length of a specified linestring https //docs ocient com/linestring constructors#ebpjz geospatial linestring constructor creates a linestring based on the specified inputs https //docs ocient com/linestring functions#oxtog geospatial linestring constructor returns a linestring that is a substring of a specified line that starts and ends at the specified fractions of its total length https //docs ocient com/spatial operators#3iz1q geospatial spatial operators returns the longest linestring between two given geospatial arguments https //docs ocient com/spatiotemporal operators#b0irl geospatial spatiotemporal measu with the specified two linestring timestamp array pairs, this function returns a two point linestring that represents the maximum distance between points at a concurrent time https //docs ocient com/spatial operators#defdz geospatial spatial operators returns a polygon with vertices that represent the minimum bounding box for the specified coordinates https //docs ocient com/linestring constructors#rws1u geospatial linestring constructor alias for st linestring https //docs ocient com/point constructors#gkzda geospatial point constructors alias for st point https //docs ocient com/polygon constructors#6pbpb geospatial polygon constructors alias for st polygon https //docs ocient com/spatial measurement#phlaj geospatial spatial measurement returns maximum distance between the specified arguments https //docs ocient com/spatiotemporal measurement#w9jwl geospatial spatiotemporal measu returns the two dimensional interpolated maximum cotemporal distance between two linestring timestamp array pairs in the specified unit of measurement https //docs ocient com/attribute functions#viwyj geospatial attribute functions returns an integer representing the number of bytes in memory required to store the specified geography https //docs ocient com/spatial operators#fpi0l geospatial spatial operators returns the smallest circle polygon that contains the specified geographic object https //docs ocient com/spatial operators#d1pyi geospatial spatial operators returns an array of geographies that represents the parts of the union of the geographies in the first array that do not intersect with the union of geographies in the second array https //docs ocient com/spatial measurement#1mqxj geospatial spatial measurement calculates the shortest distance between any point along a euclidean line segment in three dimensional space and the surface of the earth https //docs ocient com/spatial operators#133ti geospatial spatial operators when you specify two arrays of geospatial objects, this function returns an array of any intersections https //docs ocient com/spatial operators#ml5tm geospatial spatial operators when you specify two arrays of geospatial objects, this function returns an array of any geospatial values that do not intersect https //docs ocient com/spatial operators#pfgmy geospatial spatial operators when you specify two arrays of geospatial objects, this function returns one array that represents a union of all geographies in both arrays https //docs ocient com/attribute functions#e510d geospatial attribute functions alias for st coorddim https //docs ocient com/attribute functions#e510d geospatial attribute functions alias for st coorddim https //docs ocient com/attribute functions#xr f1 geospatial attribute functions returns an integer representing the number of point values in a specified geography https //docs ocient com/spatial operators#sfvut geospatial spatial operators returns the number of rings of the specified polygon, including both interior and exterior rings https //docs ocient com/spatial operators#jueb9 geospatial spatial operators returns the number of interior rings of the specified polygon https //docs ocient com/spatial operators#jueb9 geospatial spatial operators returns the number of interior rings of the specified polygon https //docs ocient com/attribute functions#xr f1 geospatial attribute functions returns an integer representing the number of point values in a specified geography https //docs ocient com/spatial relationships#zejvi geospatial spatial relationships returns true if both geographic arguments are of the same dimension and they intersect each other, but neither contains the other https //docs ocient com/spatial measurement#yakxo geospatial spatial measurement returns the length of the exterior (outer ring) of the polygon in the specified unit of measurement https //docs ocient com/spatial measurement#b0b5l geospatial spatial measurement alias for st perimeter https //docs ocient com/point constructors#gmbuv geospatial point constructors creates a point from the specified input arguments https //docs ocient com/point constructors#4z6cg geospatial point constructors alias for st point creates a point using an ewkt formatted char as an input argument https //docs ocient com/point constructors#i8vhl geospatial point constructors creates a point represented by the specified geohash https //docs ocient com/point constructors#57hsc geospatial point constructors creates a point represented by the specified geojson value as an input argument https //docs ocient com/point constructors#kzlh5 geospatial point constructors alias for st point(char) https //docs ocient com/point constructors#ghzzt geospatial point constructors alias for st point(binary) https //docs ocient com/spatial relationships#vfqoe geospatial spatial relationships returns true if the geographic object is inside a circle that is centered at the specified point coordinates and with the specified radius https //docs ocient com/linestring functions# bw4x geospatial linestring constructor returns the point value at a specified index of the given linestring https //docs ocient com/spatial operators#kit l geospatial spatial operators returns a point guaranteed to intersect the specified geospatial object https //docs ocient com/polygon constructors#bo6zb geospatial polygon constructors creates a polygon https //docs ocient com/polygon constructors#uoent geospatial polygon constructors creates a polygon using an ewkt formatted char as an input argument alias for the st polygon constructor https //docs ocient com/polygon constructors#dn7jn geospatial polygon constructors creates a polygon from the specified point, point array, linestring, or polygon geography https //docs ocient com/polygon constructors#bkcdd geospatial polygon constructors alias for st polygon(char) https //docs ocient com/polygon constructors# geye geospatial polygon constructors alias for st polygon(binary) https //docs ocient com/spatial operators#srzq0 geospatial spatial operators returns a point by projecting a distance and an azimuth value from the specified starting point value https //docs ocient com/spatial operators#xmv2t geospatial spatial operators returns a new geospatial object with all point values rounded to the specified decimal precision docid\ cai7h lh9vyvdihc8nrh geospatial spatial relationships returns the https //postgis net/workshops/postgis intro/de9im html intersection string that represents the nature of the intersection with the specified geographies https //docs ocient com/linestring functions#kvxp7 geospatial linestring constructor removes a point value at a specified index from the specified line https //docs ocient com/spatial operators#pf3t1 geospatial spatial operators returns a new geospatial object with no repeated point values https //docs ocient com/spatial operators#rxt6z geospatial spatial operators returns a new geospatial object with the vertexes reversed https //docs ocient com/spatial operators#irtd8 geospatial spatial operators returns a geospatial object that the function modifies to have no segment longer than the specified max segment length in meters https //docs ocient com/linestring functions#ibz1n geospatial linestring constructor replaces a point value in a given linestring at a specified index the function returns the altered linestring with the replaced point https //docs ocient com/spatial operators#rxw4c geospatial spatial operators returns the shortest linestring between two specified geospatial arguments https //docs ocient com/spatiotemporal operators#77vdg geospatial spatiotemporal measu when you specify two linestring timestamp array pairs, this function returns a linestring with two points that represents the minimum distance between points at a concurrent time https //docs ocient com/spatial operators#3xjsg geospatial spatial operators returns a simplified version of the specified geography, which is either a point or linestring https //docs ocient com/spatial operators#zxrjq geospatial spatial operators returns a polygon array that represents a simplified version of the specified geography, which is either a point, linestring, or polygon https //docs ocient com/spatial operators#jmvec geospatial spatial operators returns a new geography value with all point values rounded to the specified precisions https //docs ocient com/attribute functions#cmmog geospatial attribute functions returns the epsg code of the spatial reference identifier (srid) of the input geography https //docs ocient com/linestring functions#h 5xu geospatial linestring constructor returns the starting point value of the line https //docs ocient com/spatial operators#ashih geospatial spatial operators returns a geographic array that contains the parts that are not common between two geographic objects, geo1 and geo2 https //docs ocient com/spatiotemporal measurement#zzjsu geospatial spatiotemporal measu returns the total number of seconds spent in the intersection result calculated by the spatiotemporal version of st intersection https //docs ocient com/spatial relationships#nd7i5 geospatial spatial relationships returns true if the only point values in common between the two geographic arguments lie in the union of their boundaries https //docs ocient com/spatial operators#tinux geospatial spatial operators performs a union of the input geography values to produce a geographic array https //docs ocient com/polygon constructors#wyix0 geospatial polygon constructors returns the database internal representation of the whole earth polygon https //docs ocient com/spatial relationships#gg mq geospatial spatial relationships alias for st contains https //docs ocient com/attribute functions#ujh7v geospatial attribute functions returns the x value of the specified point https //docs ocient com/attribute functions#xlkrv geospatial attribute functions returns the maximum x value of the specified geography https //docs ocient com/attribute functions#uw6gs geospatial attribute functions returns the minimum x value of the specified geography https //docs ocient com/attribute functions#rrn f geospatial attribute functions returns the y value of the specified point https //docs ocient com/attribute functions#c2ior geospatial attribute functions returns the maximum y value of specified geography https //docs ocient com/attribute functions# i5s0 geospatial attribute functions returns the minimum y value of specified geography https //docs ocient com/character and binary functions#ifrwf character and binary functions returns true if string starts with substring and false otherwise https //docs ocient com/aggregate functions aggregate functions alias for stdev https //docs ocient com/aggregate functions aggregate functions alias for stdevp https //docs ocient com/aggregate functions aggregate functions alias for stdev https //docs ocient com/aggregate functions aggregate functions sample standard deviation https //docs ocient com/aggregate functions aggregate functions population standard deviation https //docs ocient com/sorted aggregate functions sorted aggregate functions returns a string concatenated from every row from the expression the delimiter argument is optional https //docs ocient com/array functions and operators array functions converts the string representation of an array (e g , 'int\[1,2,null]' ) into an array https //docs ocient com/tuple functions and operators#ii1hv tuple functions converts the string representation of a tuple (e g 'tuple<\<int,bigint,char>>(1,2,null)' ) into a tuple https //docs ocient com/character and binary functions#c8xqo character and binary functions equivalent to using locate as locate(substring, string) note the reversed argument order https //docs ocient com/character and binary functions#ysvy0 character and binary functions alias for substring https //docs ocient com/character and binary functions#smvvg character and binary functions returns the substring of a character or binary value https //docs ocient com/network type functions#i6qqu network type functions c omputes the prefix from an ip or ipv4 value and the size of the prefix https //docs ocient com/aggregate functions aggregate functions sum over the set https //docs ocient com/matrix functions and operators matrix functions returns svd decomposition of a matrix as a tuple of 3 matrixes https //docs ocient com/aggregate functions aggregate functions the population over the set https //docs ocient com/math functions and operators#oniqb math functions returns the tangent of x https //docs ocient com/math functions and operators#blv9a math functions returns the hyperbolic tangent of x https //docs ocient com/scalar data conversion functions scalar data conversion functions parses the string to create a time value the string must be in the form 'hh\ mm\[ sssssssss]' https //docs ocient com/scalar data conversion functions scalar data conversion functions parses a string and makes a timestamp value the string must be in the format 'yyyy mm dd\[ hh\ mm]\[ sssssssss]' https //docs ocient com/date and time functions#qcm6u date and time functions convert timestamp into nanoseconds after epoch as bigint https //docs ocient com/transform data in data pipelines#dhuvc special data pipeline transformation functions create the specified number of copies of any json object in an array https //docs ocient com/character and binary functions#uxg6v character and binary functions converts a numeric, date, or timestamp value into a char date type https //docs ocient com/formatting functions#h9rnn formatting functions converts a character value with the specified format to a date type https //docs ocient com/formatting functions#2jgru formatting functions converts a character value with the specified format to a decimal type https //docs ocient com/formatting functions#h4h6f formatting functions converts a character value with the specified format to a timestamp type https //docs ocient com/special data pipeline transformation functions#kujla special data pipeline transformation functions transforms an array based on the logic in a lambda expression https //docs ocient com/character and binary functions#oqsoi character and binary functions replaces specified characters in a provided string with a separate set of characters https //docs ocient com/matrix functions and operators matrix functions returns transpose of the matrix https //docs ocient com/character and binary functions#8p8 k character and binary functions alias for btrim trim leading and trailing blanks from the string https //docs ocient com/math functions and operators#qywhl math functions returns x truncated to y decimal places https //docs ocient com/math functions and operators#9mx3f math functions alias for trunc https //docs ocient com/tuple functions and operators#ii1hv tuple functions construct a tuple with the specified elements types of the tuple are inferred from the inner elements https //docs ocient com/tuple functions and operators#ii1hv tuple functions construct a tuple with the specified elements null is also supported as an element https //docs ocient com/array functions and operators array functions construct an array of sql type type giving the elements https //docs ocient com/character and binary functions#9g59w character and binary functions alias for upper https //docs ocient com/array functions and operators array functions expand each element in an input array out to an individual row https //docs ocient com/character and binary functions#kdf0u character and binary functions convert string to upper case https //docs ocient com/date and time functions#pasmr date and time functions the seconds part of a time value, including fractional parts, returned as an integer the function multiplies the seconds part of the value by 1,000,000 https //docs ocient com/scalar data conversion functions scalar data conversion functions parses the string and makes a universally unique identifier (uuid) value the string must be a valid uuid https //docs ocient com/aggregate functions aggregate functions alias for variancep https //docs ocient com/aggregate functions aggregate functions alias for variance https //docs ocient com/aggregate functions aggregate functions sample variance https //docs ocient com/aggregate functions aggregate functions population variance https //docs ocient com/matrix functions and operators matrix functions returns the argmax of a one dimensional matrix or vector https //docs ocient com/matrix functions and operators matrix functions returns the argmin of a one dimensional matrix or vector https //docs ocient com/matrix functions and operators matrix functions returns the maximum of elements in a one dimensional matrix/vector https //docs ocient com/matrix functions and operators matrix functions returns the minimum of elements in a one dimensional matrix/vector https //docs ocient com/matrix functions and operators matrix functions returns the sum of elements in a one dimensional matrix/vector https //docs ocient com/other functions and expressions#tdnug system functions returns the version of the database to which the client is currently connected https //docs ocient com/date and time functions#7lvfb date and time functions returns the iso 8601 week number, as an integer, of the specified timestamp or date value https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type weeks to be used in date calculations https //docs ocient com/transform data in data pipelines#tgsmc special data pipeline transformation functions creates n equal width buckets in the range \[min,max) as a histogram https //docs ocient com/date and time functions# mxpe date and time functions extracts the year portion of a timestamp or date as an integer https //docs ocient com/scalar data conversion functions scalar data conversion functions converts an integral value to an interval value of type years https //docs ocient com/matrix functions and operators matrix functions returns a zero matrix of the specified (row, col) dimensions https //docs ocient com/special data pipeline transformation functions#yc d5 special data pipeline transformation functions merges two or more input arrays, element wise, into a single array using the trailing combining function https //docs ocient com/other functions and expressions#b8ya5 conditional functions if x is null, returns 0 otherwise, returns x https //docs ocient com/window aggregate functions#0glyf window aggregate functions zscore of the sample based on the stddev() function https //docs ocient com/window aggregate functions#d2ogs window aggregate functions zscore of the sample based on the stddevp() function