ACOS
The ACOS function returns the arc-cosine of the input argument; that is, the angle (in radians) whose cosine is x.
Syntax
ACOS (x)
Remarks
The table lists the valid input argument data types and the resulting output data types.
Data Type of Argument | Output Type | Notes |
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT | FLOAT | Input argument is between -1.0 and +1.0. Output value is in radians. |
NULL | NULL | |
Example
SELECT ACOS(0.8660254037844387)
The result is 0.5235987755982987 (pi/6) radians, which is 30 degrees.