ATAN Function

Returns the arctangent in radians.

Category: Trigonometric
Alias: ARTAN
Returned data type: DOUBLE

Syntax

ATAN(expression)

Arguments

expression

specifies any valid SQL expression that evaluates to a numeric value.

Data type DOUBLE
See <sql-expression>
FedSQL Expressions

Details

The ATAN function returns the 2-quadrant arctangent (inverse tangent) of the argument. The value that is returned is the angle (in radians) whose tangent is x and whose value ranges from - pi slash 2 to pi slash 2. If the argument is missing, then ATAN returns a missing value.

Comparisons

The ATAN function is similar to the ATAN2 function except that ATAN2 calculates the arc tangent of the angle from the values of two arguments rather than from one argument.

Example

The following statements illustrate the ATAN function:
Statements
Results
select atan(0);
0
select atan(1);
0.785398
select atan(-9.0);
-1.46014
Last updated: February 23, 2017