In structured query language SQL
, we have a trigonometric function, SINH()
. SINH()
calculates the hyperbolic sine of a number. This method accepts a Double-Precision
value as a parameter and returns the hyperbolic sine (floating-point value). The return value will be an angle in radians.
Figure 1 shows the mathematical representation of the hyperbolic sine method. Figure 2 represents the graphical behavior of SINH()
between the interval -4 to +4.
SINH(α) //α should be Radian angle
To convert degrees to radians, use this formula:
Radian angle = , where = 3.14 and is the degree angle.
The SINH()
method requires a double-precision floating-point value as an argument.
Usually, this double-precision floating-point number takes
64-bits
in computer memory.
SINH()
returns the hyperbolic sine (floating-point number) of the value that is sent as the parameter.
NULL
as an argument, SINH()
returns NULL
.0
as an argument, SINH()
returns 0
.In the following example, we demonstrate how to use SINH(α)
in SQL
. We have multiple scenarios and their behavior for different values.
-- Example showing how to use SINH(α)/*Positive number*/SELECT SINH(4); -- return 27.289917197128/*Negative number*/select SINH(-1); -- return -1.175201193644/*Fractional number*/select SINH(0.6); -- return 0.636653582148