ASIN

The ASIN function returns the arcsine of the input argument; that is, the angle (in radians) whose sine is x.

Syntax

ASIN (x) 

Remarks

The table lists the valid input argument data types and the resulting output data types.

Data Type of Argument	Output Type	Notes
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	FLOAT	Input value is between ‑1.0 and +1.0. Output value is in radians.
NULL	NULL

Example

SELECT ASIN(0.5);

The result is 0.5235987755982989 radians, which is 30 degrees.