Function

Creates an ABS(expr) function that returns the absolute value of the given numeric expression.

Creates an ACOS(expr) function that returns the inverse cosine of the given numeric expression.

Creates an ASIN(expr) function that returns the inverse sin of the given numeric expression.

Creates an ATAN(expr) function that returns the inverse tangent of the numeric expression.

Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r, theta).

Creates an AVG(expr) function expression that returns the average of all the number values in the group of the values expressed by the given expression.

Creates a CEIL(expr) function that returns the ceiling value of the given numeric expression.

Creates a CONTAINS(expr, substr) function that evaluates whether the given string expression contains the given substring expression or not.

Creates a COS(expr) function that returns the cosine of the given numeric expression.

ENTERPRISE EDITION API

Creates a COUNT(expr) function expression that returns the count of all values in the group of the values expressed by the given expression. Null expression is count *

Creates a DEGREES(expr) function that returns the degrees value of the given radians value expression.

Creates an E() function that return the value of the mathematical constant 'e'.

ENTERPRISE EDITION API

Creates a EXP(expr) function that returns the value of 'e' power by the given numeric expression.

Creates a FLOOR(expr) function that returns the floor value of the given numeric expression.

Creates a LENGTH(expr) function that returns the length of the given string expression.

Creates an LN(expr) function that returns the natural log of the given numeric expression.

Creates a LOG(expr) function that returns the base 10 log of the given numeric expression.

Creates a LOWER(expr) function that returns the lowercase string of the given string expression.

Creates a LTRIM(expr) function that removes the whitespace from the beginning of the given string expression.

Creates a MAX(expr) function expression that returns the maximum value in the group of the values expressed by the given expression.

Creates a MILLIS_TO_STR(expr) function that will convert a numeric input representing milliseconds since the Unix epoch into a full ISO8601 date and time string in the device local time zone.

Creates a MILLIS_TO_UTC(expr) function that will convert a numeric input representing milliseconds since the Unix epoch into a full ISO8601 date and time string in UTC time.

Creates a MIN(expr) function expression that returns the minimum value in the group of the values expressed by the given expression.

Creates a PI() function that returns the mathematical constant Pi.

Creates a POWER(base, exponent) function that returns the value of the given base expression power the given exponent expression.

ENTERPRISE EDITION API

Creates a RADIANS(expr) function that returns the radians value of the given degrees value expression.

Creates a ROUND(expr) function that returns the rounded value of the given numeric expression.

Creates a ROUND(expr, digits) function that returns the rounded value to the given number of digits of the given numeric expression.

Creates a RTRIM(expr) function that removes the whitespace from the end of the given string expression.

Creates a SIGN(expr) function that returns the sign (1: positive, -1: negative, 0: zero) of the given numeric expression.

Creates a SIN(expr) function that returns the sin of the given numeric expression.

Creates a SQRT(expr) function that returns the square root of the given numeric expression.

ENTERPRISE EDITION API

Creates a STR_TO_MILLIS(expr) that will convert an ISO8601 datetime string into the number of milliseconds since the unix epoch. Valid date strings must start with a date in the form YYYY-MM-DD (time only strings are not supported).

Creates a STR_TO_UTC(expr) that will convert an ISO8601 datetime string into a full ISO8601 UTC datetime string. Valid date strings must start with a date in the form YYYY-MM-DD (time only strings are not supported).

Creates a SUM(expr) function expression that return the sum of all number values in the group of the values expressed by the given expression.

Creates a TAN(expr) function that returns the tangent of the given numeric expression.

Creates a TRIM(expr) function that removes the whitespace from the beginning and the end of the given string expression.

Creates a TRUNC(expr) function that truncates all of the digits after the decimal place of the given numeric expression.

Creates a TRUNC(expr, digits) function that truncates the number of the digits after the decimal place of the given numeric expression.

Creates a UPPER(expr) function that returns the uppercase string of the given string expression.