ATAN
The ATAN
function returns the arc tangent of Expression
.
SQL syntax
ATAN(Expression)
Parameters
ATAN
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
can be in an unbounded range.ATAN
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 ATAN
function to return the arc tangent of .3
.
Command> SELECT ATAN(.3) "Arc tangent of .3" FROM dual; < .2914567944778670919956046214328911935013 > 1 row found.