ASIN()

All functions > MATH > ASIN()

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

Signatures

Arcsine

Returns: Angle in radians, in [-π/2, π/2]

ASIN(number: T) → DOUBLE

With:

• T : Floating-point type (FLOAT, DOUBLE)

Signature notes:

• Input must be in [-1, 1]
• ASIN(0.0) = 0, ASIN(1.0) = π/2, ASIN(-1.0) = -π/2
• Returns NaN for inputs outside [-1, 1]
• Returns NULL if the input is NULL

Examples

SELECT
    f1 := ASIN(1.0E0), -- asin(1) = π/2
    f2 := ASIN(0.5E0), -- asin(0.5) = π/6
    f3 := ASIN(0.0E0), -- asin(0) = 0
    f4 := ASIN(-0.5E0) -- asin(-0.5) = -π/6
;