ASIN (TSQL Function)

Returns the arcsine, or inverse sine, of a number.

Syntax

ASIN ( float_expression )

Arguments

float_expression
is an expression of type float, in the range [-1, 1]. Values outside this range raise an error.

Return Types

Returns float.

Examples

PRINT ASIN(-1), ASIN(0), ASIN(0.5), ASIN(1);

The result is:

       -1.5707963267949|                      0|      0.523598775598299|        1.5707963267949|

With value out of range, an error is raised:

PRINT ASIN(1.1)

The result is:

<Arithmetic error. FLOAT is NaN.>
RSQL, a simple alternative to Microsoft SQL Server