DEGREES() to convert radian to degree
SELECT DEGREES( X);
Value of X is in radian.
DEGREE with PI()
SELECT DEGREES(PI())
Output is 180
We used PI(), this constant value is 3.141593.
Examples
SELECT DEGREES(PI()); // Output is 180
SELECT DEGREES(PI()/2); // Output is 90
SELECT DEGREES(PI()/3); // Output is 59.99999
This article is written by plus2net.com team.
https://www.plus2net.com
plus2net.com
▼ More on Math functions in SQL
|
SQL Video Tutorials