SQLite asin() Function

The SQLite asin() function returns the arc sine of the specified number.

Syntax

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

asin(number)

Parameters

number

Required. A number used to calculate the arcsine.

Return value

The SQLite asin() function returns the arc sine of the specified number.

If the parameter is number not between-1 to 1, the asin() function will return NULL.

If the parameter number is NULL, the asin() function will return NULL.

Examples

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

SELECT
    asin(0.5),
    asin(0.2),
    asin(-0.5),
    asin(-0.2),
    asin(1),
    asin(0),
    asin(-1),
    asin(2),
    asin(-2);

 asin(0.5) = 0.523598775598299
 asin(0.2) = 0.201357920790331
asin(-0.5) = -0.523598775598299
asin(-0.2) = -0.201357920790331
   asin(1) = 1.5707963267949
   asin(0) = 0.0
  asin(-1) = -1.5707963267949
   asin(2) =
  asin(-2) =