Muokkaa

Jaa


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 and EXP(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.