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, 254🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...