ATAN

The ATAN function returns the arc tangent of Expression.

SQL syntax

ATAN(Expression)

Parameters

ATAN has the parameter:

Parameter Description

Expression

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 to pi/2, expressed in radians.

  • If Expression is of type NUMBER, the data type returned is NUMBER. For all other numeric data types, the data type returned is BINARY_DOUBLE.

  • If the value of Expression is NULL, 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.