X is in Radian
SIN() with PI()mathematical constant PI() (π) value is 3.141593
We used ROUND() to show only two decimal places.
SIN() with RADIANS
SELECT SIN(RADIANS(0)); // Ouput is 0 SELECT SIN(RADIANS(90)); // Output is 1 SELECT ROUND(SIN(RADIANS(180)),2); // Output is 0.00
This article is written by plus2net.com team.
▼ More on Math functions in SQL