SELECT SIN( X )
X is in Radian
SIN() with PI()
mathematical constant PI() (π) value is 3.141593
SELECT ROUND(SIN(PI()),2); // Ouput is 0.00
SELECT SIN(PI()/2); // Ouput is 1
SELECT ROUND(SIN(PI()/3),2); // Ouput is 0.87
We used ROUND() to show only two decimal places.
SIN() with RADIANS
Radians function convert degree value to radian.
SELECT SIN(RADIANS(0)); // Ouput is 0
SELECT SIN(RADIANS(90)); // Output is 1
SELECT ROUND(SIN(RADIANS(180)),2); // Output is 0.00
SQL Video Tutorials