ASIN

The ASIN function returns the arc sine of the argument as an angle expressed in radians. The ASIN and SIN functions are inverse operations.

Read syntax diagramSkip visual syntax diagramASIN (expression)
expression
An expression that returns a value of any built-in numeric data type (except for DECFLOAT), character-string, or graphic-string data type. A string argument is cast to double-precision floating point before evaluating the function. For more information about converting strings to double-precision floating point, see DOUBLE_PRECISION or DOUBLE. The value must be greater than or equal to -1 and less than or equal to 1.

The data type of the result is double-precision floating point. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

The result is greater than or equal to -π /2 and less than or equal to π /2.

Example

  • Assume the host variable ASINE is a DECIMAL(10,9) host variable with a value of 0.997494987. 
      SELECT ASIN(:ASINE)
    FROM SYSIBM.SYSDUMMY1
    Returns the approximate value 1.50.