Syntax
ARC_SINE(Argument)
Description
The ARC_SIN SQL scalar function returns the arc sine of a number, in radians.
The ARC_SINE and SINE functions are inverse operations.
The argument must be a number whose value is 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 in the range (-&pi./2, &pi./2).
Example
Assume the column ASINE is a decimal (10,9) column with a value of 0.997494987.
ARC_SINE(ASINE)
Returns the approximate value 1.50.
List of SQL scalar functions by topic