SQL in a Nutshell, 2nd Edition

Name

EXP

Synopsis

The EXP function returns the value of the mathematical constant e (approximately 2.718281) raised to the power of a specified number.

SQL2003 Syntax

All platforms support the SQL2003 syntax:

EXP( expression )

Example

The following example uses EXP to return an approximation of e:

SELECT EXP(1) FROM dual;
    EXP(1)
----------
2.71828183
Use LN to go in the opposite direction.