ASIN
All functions > MATH > ASIN
Returns the arcsine (inverse sine) of a number in radians.
Syntax
ASIN(number: T) → DOUBLE
sql
Type Parameters:
T
: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)
Arguments
Parameter | Type | Required | Description |
---|---|---|---|
number | T | Yes | A number between -1 and 1 (inclusive) |
Returns
DOUBLE - Arcsine in radians (between -π/2 and π/2)
Notes
- Input must be in the range [-1, 1]
- Returns values in the range [-π/2, π/2] radians
ASIN(0) = 0
,ASIN(1) = π/2
,ASIN(-1) = -π/2
- Returns NULL if input is NULL
- Returns NaN for inputs outside [-1, 1]
- Inverse of SIN function:
ASIN(SIN(x)) = x
for x in [-π/2, π/2]