ATAN2()¶
Returns the angle of the point
(X, Y)from the positive x-axis in radians. UnlikeATAN(Y/X),ATAN2(Y, X)uses the signs of both arguments to determine the correct quadrant of the result, including whenXis zero.
Description¶
The ATAN2() function returns the angle (in radians) between the positive x-axis and the point (X, Y). Both X and Y must be values implicitly convertible to DOUBLE; BIT is not supported. The result is in the range [-PI, PI].
Syntax¶
> ATAN2(Y, X)
Arguments¶
Arguments |
Description |
|---|---|
Y |
Required. The y-coordinate. |
X |
Required. The x-coordinate. |
Examples¶
DROP DATABASE IF EXISTS atan2_tests;
CREATE DATABASE atan2_tests;
USE atan2_tests;
SELECT ATAN2(1, 1) AS quadrant1;
SELECT ATAN2(1, -1) AS quadrant2;
SELECT ATAN2(-1, -1) AS quadrant3;
SELECT ATAN2(-1, 1) AS quadrant4;
SELECT ATAN2(0, -1) AS pi_result;
SELECT ATAN2(NULL, 1) AS null_y;
SELECT ATAN2(1, NULL) AS null_x;
DROP DATABASE atan2_tests;