EXP()

Description

The EXP() function returns the value of e (the base of natural logarithms) raised to the power of X.

Syntax

  1. > EXP(number)

Arguments

ArgumentsDescription
numberRequired. Any numeric data type supported now.

Examples

  1. > drop table if exists t1;
  2. > create table t1(a int ,b float);
  3. > insert into t1 values(-4, 2.45);
  4. > insert into t1 values(6, -3.62);
  5. > select exp(a), exp(b) from t1;
  6. +----------+---------+
  7. | exp(a) | exp(b) |
  8. +----------+---------+
  9. | 0.0183 | 11.5883 |
  10. | 403.4288 | 0.0268 |
  11. +----------+---------+