← Back Home

FX - Math @ Data transformation (ETL) @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Math

math abs math base_to_base math acos math asin math atan math atan2 math avg math bit_and math bit_or math bit_xor math cbrt math ceil math ceiling math cos math cosh math cot math decimal_format math deg_to_rad math e math exp math expm1 math floor math hypot math log math log10 math log1p math max math min math mod math order_int math order_long math order_double math order_float math pi math pow math power math rad_to_deg math random math rint math round math sign math signum math sin math sinh math sqrt math tan math tanh math ulp

math abs <number>

Description

get the absolute value of a number

Parameters

number: A number - Number - required

admin
math abs -56

mentdb
56

math base_to_base <number> <fromBase> <toBase>

Description

Get a number in another base

Parameters

number: A number - Number - required
fromBase: A number - Number - required
toBase: A number - Number - required

admin
math base_to_base 3 10 2

mentdb
11

math acos <number>

Description

get the arc cosin of a number

Parameters

number: A number - Number - required

admin
math acos 42

mentdb
NaN

math asin <number>

Description

get the arc sin of a number

Parameters

number: A number - Number - required

admin
math asin 0.5

mentdb
0.5235987755982989

math atan <number>

Description

get the arc tangent of a number

Parameters

number: A number - Number - required

admin
math atan 42

mentdb
1.5469913006098266

math atan2 <number1> <number2>

Description

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

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math atan2 4 2

mentdb
1.1071487177940904

math avg <json_array>

Description

get the avg of a json array of vales

Parameters

json_array: A json array (of double values) - String - required

admin
math avg "[10 20]"

mentdb
15.0

math bit_and <number1> <number2>

Description

the bitwise & operation

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math bit_and 4456 234

mentdb
104

math bit_or <number1> <number2>

Description

the bitwise or operation

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math bit_or 4456 234

mentdb
4586

math bit_xor <number1> <number2>

Description

the bitwise xor operation

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math bit_xor 4456 234

mentdb
4482

math cbrt <number>

Description

returns the cube root of a double value

Parameters

number: A number - Number - required

admin
math cbrt 42

mentdb
3.4760266448864496

math ceil <number>

Description

get the smallest integer value not less than the number specified as an argument

Parameters

number: A number - Number - required

admin
math ceil 1.2

mentdb
2

math ceiling <number>

Description

get the smallest integer value not less than the number specified as an argument

Parameters

number: A number - Number - required

admin
math ceiling 1.2

mentdb
2

math cos <number>

Description

get the cosine of a number

Parameters

number: A number - Number - required

admin
math cos 42

mentdb
-0.39998531498835127

math cosh <number>

Description

get the hyperbolic cosine of a number

Parameters

number: A number - Number - required

admin
math cosh 42

mentdb
8.696374707602505E17

math cot <number>

Description

get the cotangent of a number

Parameters

number: A number - Number - required

admin
math cot 42

mentdb
0.4364167060752729

math decimal_format <number> <pattern> <decimalSeparator> <groupingSeparator>

Description

convert a number to another formated decimal number

Parameters

number: A number - Number - required
pattern: The pattern - String - required
decimalSeparator: The decimal separator - String - required
groupingSeparator: The grouping separator - String - required

admin
math decimal_format 42.456 "##.##" "." " "

mentdb
42.46

math deg_to_rad <number>

Description

converts an angle measured in degrees to an approximately equivalent angle measured in radians

Parameters

number: A number - Number - required

admin
math deg_to_rad 42

mentdb
0.7330382858376184

math e

Description

get the Euler's number value approximately.

admin
math e

mentdb
2.718281828459045

math exp <number>

Description

returns euler's number e raised to the power of a double value

Parameters

number: A number - Number - required

admin
math exp 42

mentdb
1.73927494152050099E18

math expm1 <number>

Description

returns e^x -1

Parameters

number: A number - Number - required

admin
math expm1 42

mentdb
1.73927494152050099E18

math floor <number>

Description

get the largest integer value not greater than a number specified as argument

Parameters

number: A number - Number - required

admin
math floor 1.2

mentdb
1

math hypot <number1> <number2>

Description

returns sqrt(x^2 +y^2) without intermediate overflow or underflow

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math hypot 4456 234

mentdb
4462.139845410496

math log <number>

Description

get the natural logarithm of the argument

Parameters

number: A number - Number - required

admin
math log 42

mentdb
3.7376696182833684

math log10 <number>

Description

get the base 10 logarithm of the argument

Parameters

number: A number - Number - required

admin
math log10 42

mentdb
1.6232492903979006

math log1p <number>

Description

returns the natural logarithm of the sum of the argument and 1

Parameters

number: A number - Number - required

admin
math log1p 42

mentdb
3.7612001156935624

math max <number1> <number2>

Description

returns the greater number between the two parameters sent.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math max 4456 234

mentdb
4456

math min <number1> <number2>

Description

returns the smaller number between the parameters sent.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math min 4456 234

mentdb
234

math mod <number1> <number2>

Description

returns the result of the modulo of the 2 numbers sent as parameters.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math mod 4456 234

mentdb
10

math order_int <jsonArray>

Description

Return an ordered array of int

Parameters

jsonArray: A JSON Array - String - required

admin
math order_int "[8, 6, 5]"

mentdb
"[5, 6, 8]"

math order_long <jsonArray>

Description

Return an ordered array of long

Parameters

jsonArray: A JSON Array - String - required

admin
math order_long "[8, 6, 5]"

mentdb
"[5, 6, 8]"

math order_double <jsonArray>

Description

Return an ordered array of double

Parameters

jsonArray: A JSON Array - String - required

admin
math order_double "[8, 6, 5]"

mentdb
"[5, 6, 8]"

math order_float <jsonArray>

Description

Return an ordered array of float

Parameters

jsonArray: A JSON Array - String - required

admin
math order_float "[8, 6, 5]"

mentdb
"[5, 6, 8]"

math pi

Description

get pi value

admin
math pi

mentdb
3.141592653589793

math pow <number1> <number2>

Description

get the value 'number1' and returns 'number 1' to the power of 'number'2'.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math pow 0.5 7

mentdb
0.0078125

math power <number1> <number2>

Description

get the value 'number1' and returns 'number 1' to the power of 'number'2'.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math power 0.5 7

mentdb
0.0078125

math rad_to_deg <number>

Description

converts an angle measured in radians to an approximately equivalent angle measured in degrees

Parameters

number: A number - Number - required

admin
math rad_to_deg 42

mentdb
2406.4227395494577

math random <number>

Description

get the random number between 0 and the given argument 'number'.

Parameters

number: A number - Number - required

admin
math random 42

mentdb
1

math rint <number>

Description

returns the double value that is closest in value to the argument and is equal to a mathematical integer

Parameters

number: A number - Number - required

admin
math rint 42

mentdb
42

math round <number1> <number2>

Description

rounds 'number 1' up to a precision specified by 'number 2'.

Parameters

number1: A number - Number - required
number2: A number - Number - required

admin
math round 1.23654 2

mentdb
1.24

math sign <number>

Description

get the sign of a number

Parameters

number: A number - Number - required

admin
math sign 42

mentdb
1

math signum <number>

Description

get the sign of a number and returns 1 if the number is positive and -1 if the number is negative.

Parameters

number: A number - Number - required

admin
math signum 42

mentdb
1

math sin <number>

Description

get the sine of a number

Parameters

number: A number - Number - required

admin
math sin 42

mentdb
-0.9165215479156338

math sinh <number>

Description

get the hyperbolic sine of a number

Parameters

number: A number - Number - required

admin
math sinh 42

mentdb
8.696374707602505E17

math sqrt <number>

Description

get the square root of a non-negative number of the argument

Parameters

number: A number - Number - required

admin
math sqrt 42

mentdb
6.48074069840786

math tan <number>

Description

get the tangent of a number

Parameters

number: A number - Number - required

admin
math tan 42

mentdb
2.2913879924374863

math tanh <number>

Description

get the hyperbolic tangent of a number

Parameters

number: A number - Number - required

admin
math tanh 42

mentdb
1

math ulp <number>

Description

returns the size of an ulp of the argument. an ulp of a double value is the positive distance between this floating-point value and the double value next larger in magnitude

Parameters

number: A number - Number - required

admin
math ulp 42

mentdb
7.105427357601002E-15

start: 2026-02-02end: 2026-02-02v_start: 401v_end: