Collections:
ATAN2() - 2-Argument Arctangent
How to calculate the angle of vector of X and Y using the ATAN2() function?
✍: FYIcenter.com
ATAN2(Y, X) is a MySQL built-in function that
calculates the angle of a given vector ending at (X, Y).
For example:
SELECT ATAN2(1, 0), ATAN2(0, 1), ATAN2(-1, 0); -- +--------------------+-------------+---------------------+ -- | ATAN2(1, 0) | ATAN2(0, 1) | ATAN2(-1, 0) | -- +--------------------+-------------+---------------------+ -- | 1.5707963267948966 | 0 | -1.5707963267948966 | -- +--------------------+-------------+---------------------+
Reference information of the ATAN2() function:
ATAN2(Y, X): ang Returns the arc tangent of the two variables X and Y. It is similar to calculating the arc tangent of Y / X, except that the signs of both arguments are used to determine the quadrant of the result. Arguments, return value and availability: Y, X: Required. The end point of the input vector. ang: Return value. The angle of the input vector. Available since MySQL 4.0.
Related MySQL functions:
⇒ BIN() - Converting Integer to Binary String
⇐ ATAN() - Arctangent Trigonometric Value
2023-11-15, 1130🔥, 0💬
Popular Posts:
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...