Function

expect object Function(source)

Query functions.

actual object Function(source)
actual object Function(source)

Functions

Link copied to clipboard
expect fun abs(operand: Expression): Expression

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

actual fun abs(operand: Expression): Expression
actual fun abs(operand: Expression): Expression
Link copied to clipboard
expect fun acos(operand: Expression): Expression

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

actual fun acos(operand: Expression): Expression
actual fun acos(operand: Expression): Expression
Link copied to clipboard
expect fun asin(operand: Expression): Expression

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

actual fun asin(operand: Expression): Expression
actual fun asin(operand: Expression): Expression
Link copied to clipboard
expect fun atan(operand: Expression): Expression

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

actual fun atan(operand: Expression): Expression
actual fun atan(operand: Expression): Expression
Link copied to clipboard

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

Link copied to clipboard
expect fun avg(operand: Expression): Expression

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.

actual fun avg(operand: Expression): Expression
actual fun avg(operand: Expression): Expression
Link copied to clipboard
expect fun ceil(operand: Expression): Expression

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

actual fun ceil(operand: Expression): Expression
actual fun ceil(operand: Expression): Expression
Link copied to clipboard
expect fun contains(operand: Expression, substring: Expression): Expression

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

actual fun contains(operand: Expression, substring: Expression): Expression
actual fun contains(operand: Expression, substring: Expression): Expression
Link copied to clipboard
expect fun cos(operand: Expression): Expression

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

actual fun cos(operand: Expression): Expression
actual fun cos(operand: Expression): Expression
Link copied to clipboard
expect fun count(operand: Expression?): Expression

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 *

actual fun count(operand: Expression?): Expression
actual fun count(operand: Expression?): Expression
Link copied to clipboard
expect fun degrees(operand: Expression): Expression

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

actual fun degrees(operand: Expression): Expression
actual fun degrees(operand: Expression): Expression
Link copied to clipboard
expect fun e(): Expression

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

actual fun e(): Expression
actual fun e(): Expression
Link copied to clipboard
expect fun exp(operand: Expression): Expression

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

actual fun exp(operand: Expression): Expression
actual fun exp(operand: Expression): Expression
Link copied to clipboard
expect fun floor(operand: Expression): Expression

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

actual fun floor(operand: Expression): Expression
actual fun floor(operand: Expression): Expression
Link copied to clipboard
expect fun length(operand: Expression): Expression

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

actual fun length(operand: Expression): Expression
actual fun length(operand: Expression): Expression
Link copied to clipboard
expect fun ln(operand: Expression): Expression

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

actual fun ln(operand: Expression): Expression
actual fun ln(operand: Expression): Expression
Link copied to clipboard
expect fun log(operand: Expression): Expression

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

actual fun log(operand: Expression): Expression
actual fun log(operand: Expression): Expression
Link copied to clipboard
expect fun lower(operand: Expression): Expression

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

actual fun lower(operand: Expression): Expression
actual fun lower(operand: Expression): Expression
Link copied to clipboard
expect fun ltrim(operand: Expression): Expression

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

actual fun ltrim(operand: Expression): Expression
actual fun ltrim(operand: Expression): Expression
Link copied to clipboard
expect fun max(operand: Expression): Expression

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

actual fun max(operand: Expression): Expression
actual fun max(operand: Expression): Expression
Link copied to clipboard
expect fun millisToString(operand: Expression): 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.

actual fun millisToString(operand: Expression): Expression
actual fun millisToString(operand: Expression): Expression
Link copied to clipboard
expect fun millisToUTC(operand: Expression): Expression

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.

actual fun millisToUTC(operand: Expression): Expression
actual fun millisToUTC(operand: Expression): Expression
Link copied to clipboard
expect fun min(operand: Expression): Expression

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

actual fun min(operand: Expression): Expression
actual fun min(operand: Expression): Expression
Link copied to clipboard
expect fun pi(): Expression

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

actual fun pi(): Expression
actual fun pi(): Expression
Link copied to clipboard
expect fun power(base: Expression, exp: Expression): Expression

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

actual fun power(base: Expression, exp: Expression): Expression
actual fun power(base: Expression, exp: Expression): Expression
Link copied to clipboard
expect fun radians(operand: Expression): Expression

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

actual fun radians(operand: Expression): Expression
actual fun radians(operand: Expression): Expression
Link copied to clipboard
expect fun round(operand: Expression): Expression

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

expect fun round(operand: Expression, digits: Expression): Expression

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

actual fun round(operand: Expression): Expression
actual fun round(operand: Expression, digits: Expression): Expression
actual fun round(operand: Expression): Expression
actual fun round(operand: Expression, digits: Expression): Expression
Link copied to clipboard
expect fun rtrim(operand: Expression): Expression

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

actual fun rtrim(operand: Expression): Expression
actual fun rtrim(operand: Expression): Expression
Link copied to clipboard
expect fun sign(operand: Expression): Expression

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

actual fun sign(operand: Expression): Expression
actual fun sign(operand: Expression): Expression
Link copied to clipboard
expect fun sin(operand: Expression): Expression

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

actual fun sin(operand: Expression): Expression
actual fun sin(operand: Expression): Expression
Link copied to clipboard
expect fun sqrt(operand: Expression): Expression

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

actual fun sqrt(operand: Expression): Expression
actual fun sqrt(operand: Expression): Expression
Link copied to clipboard
expect fun stringToMillis(operand: Expression): Expression

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).

actual fun stringToMillis(operand: Expression): Expression
actual fun stringToMillis(operand: Expression): Expression
Link copied to clipboard
expect fun stringToUTC(operand: Expression): Expression

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).

actual fun stringToUTC(operand: Expression): Expression
actual fun stringToUTC(operand: Expression): Expression
Link copied to clipboard
expect fun sum(operand: Expression): Expression

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.

actual fun sum(operand: Expression): Expression
actual fun sum(operand: Expression): Expression
Link copied to clipboard
expect fun tan(operand: Expression): Expression

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

actual fun tan(operand: Expression): Expression
actual fun tan(operand: Expression): Expression
Link copied to clipboard
expect fun trim(operand: Expression): Expression

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

actual fun trim(operand: Expression): Expression
actual fun trim(operand: Expression): Expression
Link copied to clipboard
expect fun trunc(operand: Expression): Expression

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

expect fun trunc(operand: Expression, digits: Expression): Expression

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

actual fun trunc(operand: Expression): Expression
actual fun trunc(operand: Expression, digits: Expression): Expression
actual fun trunc(operand: Expression): Expression
actual fun trunc(operand: Expression, digits: Expression): Expression
Link copied to clipboard
expect fun upper(operand: Expression): Expression

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

actual fun upper(operand: Expression): Expression
actual fun upper(operand: Expression): Expression