What is COSH( ) in SQL?
This COSH() function returns the hyperbolic cosine of a number. It accepts an angle β in radian measure, but it should be a number.
Figure 1 shows the mathematical representation of the hyperbolic cosine method.
Figure 2 represents the graphical behavior of COSH() function between -3 and +3 intervals.
Figure 1 : Mathematical Representation of COSH(θ)
Figure#2 Graphical Illustration of COSH(β)
Syntax
COSH(β) -- β is an angle measured in radians.
To convert degrees to radians, use this formula:
Radian angle = , where = 3.14 and is the degree angle.
Parameter
This COSH() method requires a floating-point number as an argument.
Usually, this double-precision floating-point number takes 64-bits of computer memory.
Return value
The COSH() function returns the hyperbolic cosine of the value that is sent as an argument.
- Passing
NULLas a parameter toCOSH()function, the function returnsNULL. - Passing
0as a parameter toCOSH()function, the function returns1.0.
Code
-- Example showing how to use COSH(β)/*Positive number*/SELECT COSH(4); -- return 27.308232836016/*Negative number*/select COSH(-1); -- return 1.543080634815/*Fractional number*/select COSH(0.8); -- return 1.337434946305