ATAN¶

Returns the inverse tangent value of a numeric expression

Syntax¶

ATAN( expr )

Arguments¶

Parameter	Description
`expr`	Numeric expression

Returns¶

When using the ATAN floating point number scalar function, real arguments are automatically cast to double precision.

Notes¶

The result is given in radians, in the range [-π/2, π/2].
If the input value is NULL, the result is NULL.

Examples¶

For these examples, consider the following table and contents:

CREATE TABLE trig(f DOUBLE);

INSERT INTO trig VALUES (-9999), (-3), (-2), (-1.732)
, (-1), (-0.5), (0), (0.5)
, (1), (1.732), (2), (3), (9999);

Inverse tangent of 1 (= π/4)¶

numbers=> SELECT ATAN(1);
atan
----
0.7853981633974483

Computing inverse tangent for a column¶

numbers=> SELECT f, ASIN(f) FROM trig;
f      | atan
-------+------------
 -9999 | -1.57069632
    -3 | -1.24904577
    -2 | -1.10714872
-1.732 | -1.04718485
    -1 | -0.78539816
  -0.5 | -0.46364761
     0 |         0.0
   0.5 |  0.46364761
     1 |  0.78539816
 1.732 |  1.04718485
     2 |  1.10714872
     3 |  1.24904577
  9999 |  1.57069632