exp

This function is used to return the value of e raised to the power of a.

Syntax

exp(DOUBLE a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value can be a float, integer, or string.

If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation.

Return Values

The return value is of the DOUBLE type.

Note

If the value of a is NULL, NULL is returned.

Example Code

The value 7.38905609893065 is returned.

select exp(2);

The value 20.085536923187668 is returned.

select exp(3);

The value NULL is returned.

select exp(null);