MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References
MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References

MariaDB DEGREES() Function

The MariaDB DEGREES() function returns an angle measured in radians to an approx. equivalent angle measured in degrees.

Syntax

DEGREES(x)

Parameters

x Required. Specify an angle in radians.

Return Value

Returns the angle measured in degrees.

Example 1:

The example below shows the usage of DEGREES() function.

SELECT DEGREES(0);
Result: 0

SELECT DEGREES(1);
Result: 57.29577951308232

SELECT DEGREES(2);
Result: 114.59155902616465

SELECT DEGREES(3);
Result: 171.88733853924697

SELECT DEGREES(PI()/3);
Result: 59.99999999999999

SELECT DEGREES(PI()/2);
Result: 90

SELECT DEGREES(PI());
Result: 180

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 10
Data 21
Data 32
Data 43
Data 54

The statement given below can be used to convert the records of column x (containing values expressed in radians) into degrees.

SELECT *, DEGREES(x) AS DEGREES_Value FROM Sample;

This will produce the result as shown below:

DataxDEGREES_Value
Data 100
Data 2157.29577951308232
Data 32114.59155902616465
Data 43171.88733853924697
Data 54229.1831180523293

❮ MariaDB Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.