ASIN

All functions > MATH > ASIN

Returns the arcsine (inverse sine) of a number in radians.

Signatures

Returns: Arcsine in radians (between -π/2 and π/2)

ASIN(number: T) → DOUBLE

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]

Examples

SELECT
    f1 := ASIN(1.0e0),  -- Arcsine of 1 (90 degrees)
    f2 := ASIN(0.5e0),  -- Arcsine of 0.5 (30 degrees)
    f3 := ASIN(0.0e0),  -- Arcsine of 0
    f4 := ASIN(-0.5e0)  -- Arcsine of -0.5 (-30 degrees)
;