SQL Server ASIN() Function

ASIN() returns the angle in radians whose sine is the specified value. The input must be between -1 and 1; values outside this range cause a domain error. The input must be a float or a type SQL Server can implicitly convert to float, and the return type is float. See Microsoft’s ASIN() reference.

Syntax

ASIN(float_expression)

float_expression is the sine value whose arcsine is returned.

Return type

ASIN() returns float.

Examples

Calculate the arcsine of 0.5; the result is in radians:

SELECT ASIN(0.5) AS angle_radians;

Convert that angle to degrees when the display requires degrees:

SELECT DEGREES(ASIN(0.5)) AS angle_degrees;

The result is 30 degrees. For cosine and tangent inverses, see ACOS() and ATAN().

Conclusion

ASIN() accepts a sine value from -1 through 1 and returns its arcsine in radians. Use DEGREES() to convert the returned angle for display in degrees.