SQL ATN2() Function Example | ATN2() in SQL

SQL ATN2() is an inbuilt function that is used for finding the arctangent of two number i.e. it returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values or points of the two specified float expressions.

SQL ATN2()

SQL ATN2() function returns the arctangent of two numbers. The SQL ATN2 function is a SQL Mathematical Function which returns the angle between the positive x-axis and the line from the origin to the point (y, x).

Syntax

SELECT ATN2(A, B);

Parameters

A, B: Two values whose arctangent value is to be calculated.

Examples

Query 1

SELECT ATN2(1, 2);

Output

0.46364760900080609

Explanation

Here, arc tangent of both the values is returned.

Query 2

SELECT ATN2 (1.3, 235.70);

Output

0.00551542985993961

Explanation

Here, arc tangent of both the values is returned.

Query 3

SELECT ATN2 (-1.3, 235.70);

Output

-5.5154298599396114E-3

Explanation

Here, arctangent value is returned which is negative.

Query 4

SELECT ATN2 (2.5 + 0.3, 5);

Output

0.510488321916776

Explanation

Here, the arc tangent value of the regular expression is returned.

Query 5

SELECT ATN2 (PI (), 2);

Output

1.00388482185389

Explanation

Here, the arc tangent value of the function PI () is returned with another normal expression.

See also

SQL ATAN()

SQL ASIN()

SQL ACOS()

SQL ABS()

SQL COS()