Switch to: V9V8V7V6V5

Trigonometry Functions

ACOS(X)

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

ASIN(X)

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

ATAN(X)

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

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

COS(X)

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

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

COSH(X)

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

SELECT COSH( 1 )
=> 1.54308

SIN(X)

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

SELECT SIN(PI());
=> 0.000000

SINH(X)

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

SELECT SINH( 1 );
=> 1.1752

TAN(X)

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

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

TANH(X)

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

SELECT TANH( 1 );
=> 0.761594