ASIN
The ASIN
function returns the arc sine of Expression
.
SQL syntax
ASIN(Expression)
Parameters
ASIN
has the parameter:
Parameter | Description |
---|---|
|
Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type. |
Description
-
Expression
must be in the range of-1
to1
.ASIN
returns a value in the range of-pi
/
2
topi
/
2
, expressed in radians. -
If
Expression
is of typeNUMBER
, the data type returned isNUMBER
. For all other numeric data types, the data type returned isBINARY_DOUBLE
. -
If the value of
Expression
isNULL
,NULL
is returned.
Example
Use the ASIN
function to return the arc sine of .3
.
Command> SELECT ASIN(.3) "Arc sine of .3" FROM dual; < .3046926540153975079720029612275291599 > 1 row found.