SQLite power() Function

The SQLite power() function returns a specified number raised to the specified power. For example, power(x, y) returns x raised to the power y.

The SQLite power() function is exactly the same as pow().

Syntax

Here is the syntax of the SQLite power() function:

power(x, y)

Parameters

x

Required.

y

Required.

Return value

SQLite power(x, y)returns x raised to the power y.

The power() function will return NULL if any parameter is NULL.

The SQLite power() function will return NULL if you provide a non numeric value.

Examples

This example shows the basic usage of the SQLite power() function:

SELECT
    power(3, 4),
    power(3.3, 1.2);

    power(3, 4) = 81.0
power(3.3, 1.2) = 4.19002609637701