Trigonometric Functions
Compute sine, cosine, tangent, and other trigonometric values.
SIN( <expr> )
Calculate the sine of the given argument, which must be in radians.
> select sin(randians(90));
1
SINH( <expr> )
Calculate the hyperbolic sine of its argument.
Support datatype: INT/DOUBLE
> select sinh(-0.2);
-0.20133600254109402
COS( <expr> )
Calculate the cosine of the given argument, which must be in radians.
> select cos(degrees(45));
0.7071067811865476
COSH( <expr> )
Calculate the hyperbolic cosine of its argument.
> select cosh(-5)
74.20994852478785
ACOSH( <expr> )
Calculate the hyperbolic cosine of its argument.
> select acosh(1.5)
0.9624236501192069
TANH( <expr> )
Computes the hyperbolic tangent of the expr
> select tanh(3.5);
0.9981778976111987
COT( <expr> )
Calculate the cotangent of the given argument, which must be in radians.
> select cot(100);
-1.702956919426469
DEGREES( <expr> )
Converts radians to degrees.
> select degrees(1);
57.29577951308232
RADIANS( <expr> )
Converts degrees to radians.
> select radians(1);
1.0471975511965976
PI( )
Returns the value of pi as float
> select pi()
3.141592654
Last updated