ATAN() function in SQL is a mathematical function utilized to compute the arctangent of a provided number. The function takes an angle, measured in radians, and returns the arctangent, also known as the inverse of the tangent. This function is used in numerous mathematical and analytical calculations, such as determining angles or performing trigonometric operations within SQL queries.
ATAN()is widely supported across various SQL database systems, including MySQL, PostgreSQL, Oracle, and Microsoft SQL Server. Review the documentation of the specific database system for implementation details.
- If the input expression is a numeric value, the
ATAN()function returns the arctangent of that value in radians.
- If the input expression is
ATAN()function also returns
This example calculates the arctangent of a specific value:
SELECT ATAN(1.5) AS Arctangent_Result;
This will result in the following output: