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

ParameterTypeRequiredDescription
numberTYesA 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]

Examples

Last update at: 2025/10/13 10:23:46