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, 1915🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...