ASIN

The ASIN function returns the arc sine of a specified number.

Syntax

ASIN ( number )

number

A  DOUBLE PRECISION number that specifies the sine, in radians, of the angle that you want.

Results

The data type of the returned value is a  DOUBLE PRECISION number. The returned value, in radians, is in the range pi/2 to pi/2.

  • If the specified number is NULL, the result of this function is NULL.
  • If the specified number is zero (0), the result of this function is zero with the same sign as the specified number.
  • If the absolute value of the specified number is greater than 1, an exception is returned that indicates that the value is out of range (SQL state 22003).

Example

splice> VALUES ASIN(0.5);
1
----------
0.5235987755982989

1 row selected

See Also