Trigonometry Functions

Returns the arc cosine of X, that is, the value whose cosine is X. Returns NULL if X is not in the range [-1, +1].

SELECT ACOS(1);
=> 0.000000
SELECT ACOS(1.0001);
=> NULL
SELECT ACOS(0);
=> 1.570796

Returns the arc sine of X, that is, the value whose sine is X. Returns NULL if X is not in the range [-1, +1].

SELECT ASIN(0.2);
=> 0.201358
SELECT ASIN('foo');
=> 0.000000

Returns the arc tangent of X, that is, the value whose tangent is X.

SELECT ATAN(2);
=> 1.107149
SELECT ATAN(-2);
=> -1.107149

Returns the cosine of X, where X is given in radians.

SELECT COS(PI());
=> -1.000000

Returns the hyperbolic cosine of X, where X is given in radians.

SELECT COSH( 1 )
=> 1.54308

Returns the sine of X, where X is given in radians.

SELECT SIN(PI());
=> 0.000000

Returns the hyperbolic sine of X, where X is given in radians.

SELECT SINH( 1 );
=> 1.1752

Returns the tangent of X, where X is given in radians.

SELECT TAN(PI()+1);
=> 1.557408

Returns the hyperbolic tangent of X, where X is given in radians.

SELECT TANH( 1 );
=> 0.761594