Skip to main content
Version: Stable-3.1

acos

Description​

Computes the arc cosine of an argument.

Syntax​

DOUBLE acos(DOUBLE arg)

Parameters​

arg: You can specify only a numeric value. This function converts the numeric value into a DOUBLE value before it computes the arc cosine of the value.

Return value​

Returns a value of the DOUBLE data type.

Usage notes​

If you specify a non-numeric value, this function returns NULL.

Examples​

mysql> select acos(-1);
+-------------------+
| acos(-1)          |
+-------------------+
| 3.141592653589793 |
+-------------------+

mysql> select acos(0);
+--------------------+
| acos(0)            |
+--------------------+
| 1.5707963267948966 |
+--------------------+

mysql> select acos(1);
+---------+
| acos(1) |
+---------+
|       0 |
+---------+

mysql> select acos("");
+----------+
| acos('') |
+----------+
|     NULL |
+----------+

keyword​

ACOS