SQLite pow() Function

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

This function functions are exactly the same as power().

Syntax

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

pow(x, y)

Parameters

x

Required.

y

Required.

Return value

The SQLite pow(x, y) returns to the y power of x.

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

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

Examples

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

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

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