MySQL ASIN() Function

The ASIN() function in MySQL calculates the arcsine (inverse sine) of a number. The arcsine is the angle whose sine is equal to the given number. The result is an angle expressed in radians.

ASIN(): Definition and Usage

ASIN() is a mathematical function primarily used in trigonometry and related fields. It's the inverse of the SIN() function; given the sine of an angle, ASIN() returns the angle itself (in radians). It's crucial to remember that the input number must be between -1 and 1 (inclusive); otherwise, the function returns NULL.

Syntax

ASIN(number)
      

Parameter Values

Examples

Calculating the Arcsine of a Positive Number

This example calculates the arcsine of 0.25.

SELECT ASIN(0.25);
      

0.25268025224796
      

Calculating the Arcsine of a Negative Number

This example shows the arcsine of -0.8.

SELECT ASIN(-0.8);
      

-0.927295218001612