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.