What is SINH( ) in SQL?

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.

Figure#1 Mathematical Representation of SINH(θ)
Figure#2 Graphical Illustration of SINH(α)
Figure#2 Graphical Illustration of SINH(α)

Syntax

SINH(α) //α should be Radian angle

To convert degrees to radians, use this formula:

Radian angle = xπ180\frac{x\pi}{180}, where π\pi = 3.14 and xx is the degree angle.

Parameters

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.

Return value

SINH() returns the hyperbolic sine (floating-point number) of the value that is sent as the parameter.

  1. On passing NULL as an argument, SINH() returns NULL.
  2. On passing 0 as an argument, SINH() returns 0.

Example

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

Free Resources