EXP (NoSQL query)
APPLIES TO: NoSQL
Returns the exponential value of the specified numeric expression.
Syntax
EXP(<numeric_expr>)
Arguments
Description | |
---|---|
numeric_expr |
A numeric expression. |
Return types
Returns a numeric expression.
Examples
The following example returns the exponential value for various numeric inputs.
SELECT VALUE {
expontentialZero: EXP(0),
exponentialTen: EXP(10),
exponentialTwenty: EXP(20)
}
[
{
"expontentialZero": 1,
"exponentialTen": 22026.465794806718,
"exponentialTwenty": 485165195.4097903
}
]
Remarks
- The constant
e
(2.718281…
), is the base of natural logarithms. - The exponent of a number is the constant
e
raised to the power of the number. For example,EXP(1.0) = e^1.0 = 2.71828182845905
andEXP(10) = e^10 = 22026.4657948067
. - The exponential of the natural logarithm of a number is the number itself:
EXP (LOG (n)) = n
. And the natural logarithm of the exponential of a number is the number itself:LOG (EXP (n)) = n
.