DPL Evaluations

abs()

Returns the absolute value for the number

acos()

Calculates the arc cosine of given value

acosh()

Calculates the arc hyperbolic cosine of given value

asin()

Calculates the arc sine of given value

asinh()

Calculates the arc hyperbolic sine of given value

atan2()

Calculates the arc tangent of two given values

atan()

Calculates the arc tangent of given value

atanh()

Calculates the arc hyperbolic tangent of given value

case()

Returns the first value that evaluates to TRUE

ceiling()

Rounds up to the next highest integer

coalesce()

Returns the first arbitrary taken argument value which is not NULL

cos()

Calculates the cosine of an angle of given value radians

cosh()

Calculates the hyperbolic cosine of given value radians

exp()

Returns the exponential function for the number

false()

Returns FALSE

floor()

Rounds down to the next lowest integer

hypot()

Calculates the hypotenuse of the triangle

if()

Returns either the first or the second argument for boolean expression

in()

Returns TRUE if one of the specified values matches with the table row

isbool()

Returns TRUE if the value is boolean

isnotnull()

Returns TRUE if the value is not NULL

isnull()

Returns TRUE if the value is NULL

isnum()

Returns TRUE if the value is a number

isstr()

Returns TRUE if the value is a string

json_append()

json_array_to_mv()

json_array(<value>)

json_extend()

json_extract(<json>,<paths>)

json_keys(<json>)

json_object(<members>)

len()

Returns the count of character amount in the string

like()

Returns TRUE if the first stated value matches with the second one

ln()

Returns the natural logarithm for the number

log()

Returns the logarithm of the first value using the second value as the base

lower()

Converts the string to lowercase

ltrim()

Trims the specified characters from the left side of string

match()

Returns either TRUE or FALSE, based on whether RegEx matches with the subject

max()

Returns the maximum of the string or the numeric values

md5()

Computes the md5 hash for provided value

min()

Returns the minimum of the string or the numeric values

mv_to_json_array()

mvzip()

now()

Returns the search start time

null()

Returns NULL

nullif()

Returns NULL if the first specified value matches with the second one

pi()

Returns the constant pi

pow()

Returns the first value to the power of the second given value

printf()

Creates a string based on provided string format and specified arguments

random()

Returns the pseudo-random integer, ranging from zero to 2³¹-1

relative_time()

Returns the UNIX time which is adjusted by the relative time specifier

replace()

Replaces specified strings with a new specified string

round()

Rounds the value to the amount of decimal specified in the second given value

rtrim()

Trims the specified characatres from the right side

searchmatch()

Returns TRUE if the search string matches with the table row

sha1()

Calculates the sha1 hash for the provided value

sha512()

Calculates the sha512 hash for the provided value

sha256()

Calculates the sha256 hash for the provided value

sin()

Calculates the sine of given value

sinh()

Calculates the hyperbolic sine of given value

spath()

Based on the location path, extracts the value from a structured data type (XML or JSON)

split()

Splits the first given value by the second delimited given value

sqrt()

Returns the square root of the value

strftime()

Takes the UNIX time and renders into a human readable format

strptime()

Takes the human readable time and renders into the UNIX time

substr()

Returns a substring based on the starting position and the length

tan()

Calculates the tangent of given value

tanh()

Calculates the hyperbolic tangent of given value

time()

Creates a new timestamp by obtaining the current instant from the system clock

tonumber()

Converts the value to a number

tostring()

Converts the value to a string

trim()

Trims the specified characters from both sides of the string

true()

Returns TRUE

typeof()

Returns a string which indicates the type

upper()

Converts the string to uppercase