ACOS()

Description

The ACOS() function returns the arccosine(given in radians) of the input number.

Syntax

1. > ACOS(number)

Arguments

Arguments Description
number Required. Any numeric data type supported now.

Examples

1. drop table if exists t1;
2. create table t1(a float,b int);
3. insert into t1 values(0.5,1);
4. insert into t1 values(-0.5,-1);

6. mysql> select acos(a),acos(b) from t1;
7. +--------------------+-------------------+
8. | acos(a)            | acos(b)           |
9. +--------------------+-------------------+
10. | 1.0471975511965976 |                 0 |
11. | 2.0943951023931957 | 3.141592653589793 |
12. +--------------------+-------------------+
13. 2 rows in set (0.01 sec)