| SIN | Syntax: | SIN(Number) | | Return value: | FLOAT | | Function type: | Numeric function | |
|
|
The SIN() function returns the sine value of "Number", where "Number" is in radians.
SIN() returns NULL if the value of "Number" is NULL.
The RADIANS() function can also be used to calculate a sine from an angle value. |
SQL Examples for the SIN function |
| select radians(45);
select sin(0.7853981633974483);
select sin(radians(45));
select sin(radians(-45));
select sin(radians(90));
select round(sin(radians(180)),16);
select sin(radians(270));
select round(sin(radians(360)),16);
|
|
| radians(45) |
|---|
| double(23) |
|---|
| 0.7853981633974483 |
|
|
| sin(0.7853981633974483) |
|---|
| double(23) |
|---|
| 0.7071067811865476 |
|
|
| sin(radians(45)) |
|---|
| double(23) |
|---|
| 0.7071067811865476 |
|
|
| sin(radians(-45)) |
|---|
| double(23) |
|---|
| -0.7071067811865476 |
|
|
| sin(radians(90)) |
|---|
| double(23) |
|---|
| 1 |
|
|
| round(sin(radians(180)),16) |
|---|
| double(33) |
|---|
| 0.0000000000000001 |
|
|
| sin(radians(270)) |
|---|
| double(23) |
|---|
| -1 |
|
|
| round(sin(radians(360)),16) |
|---|
| double(33) |
|---|
| -0.0000000000000002 |
|
|
|
| The examples were created with the MyWAY SQL manager: |
How to use the SIN() function in MySQL and MariaDB databases |
| The SIN() function in MySQL and MariaDB is used to find the sine of an angle in radians calculate. The sine of an angle is a mathematical trigonometric function that represents the ratio of the length of the side opposite the angle to the length of the hypotenuse in a right triangle. The function can be useful in various mathematical calculations, especially when dealing with angles and trigonometry. It is commonly used in scientific and engineering applications such as physics, geometry, signal processing, and more. This allows calculations with periodic or oscillating phenomena, waveforms and angles to be performed. |
|
Further MySQL und MariaDB SQL Numeric functions |
|
