MySQL ASIN() Function

In MySQL, the ASIN() function returns the arc sine of the specified number.

`ASIN()` Syntax

Here is the syntax of MySQL ASIN() function:

ASIN(number)

Parameters

number: Required. The value whose arc sine is to be returned.

Return value

In MySQL, the ASIN() function returns the arc sine of the specified number.

If the argument number is not between-1 and 1, the ASIN() function will return NULL.
If the argument number is NULL, the ASIN() function will return NULL.

`ASIN()` Examples

SELECT
    ASIN(0.5),
    ASIN(0.2),
    ASIN(-0.5),
    ASIN(-0.2),
    ASIN(1),
    ASIN(0),
    ASIN(-1),
    ASIN(2),
    ASIN(-2),
    ASIN(NULL)\G

output

*************************** 1\. row ***************************
 ASIN(0.5): 0.5235987755982989
 ASIN(0.2): 0.2013579207903308
ASIN(-0.5): -0.5235987755982989
ASIN(-0.2): -0.2013579207903308
   ASIN(1): 1.5707963267948966
   ASIN(0): 0
  ASIN(-1): -1.5707963267948966
   ASIN(2): NULL
  ASIN(-2): NULL
ASIN(NULL): NULL

On this page