Skip to main content

ATAN2

Calculates the arc tangent of two numbers, specifically the angle ( \theta ) in radians for which the tangent is the ratio of two specified numbers (y divided by x), correctly handling the signs of the inputs to determine the correct quadrant.

See also:
[SELECT]

Syntax​

SELECT ATAN2(y, x) FROM <multipartIdentifier>;

Arguments​

y
The y-coordinate (numerator) of the point.

x
The x-coordinate (denominator) of the point.

Return Value(s)​

Returns the arc tangent of y/x in radians, accounting for the correct quadrant of the angle.

Examples​

Calculate the arc tangent of the point (1,1)​

SELECT ATAN2(1, 1) AS arc_tangent_value;

This query returns π/4 or approximately 0.785, as the arc tangent of the point (1,1) corresponds to an angle of π/4 radians in the first quadrant.

Calculate the arc tangent of the point (10, -10)​

SELECT ATAN2(10, -10) AS arc_tangent_value;

This query calculates the arc tangent of the point (10, -10), resulting in 3π/4 or approximately 2.356, as the tangent of this angle is -1 in the second quadrant.