MySQL DEGREES Function

MySQL DEGREES function is one of the Numeric Function which is used to convert the radiant values into degrees. In this article we will show you, How to calculate the degrees in MySQL using Command Prompt, and Workbench with example.

MySQL DEGREES Syntax

The basic syntax of the DEGREES in MySQL is as shown below:

SELECT DEGREES (Numeric_Expression)
FROM Source

To demonstrate this DEGREES Numeric function, we are going to use the below shown data

MySQL DEGREES Function Example 1

The DEGREES Function is used to convert the radiant values to degrees. The following MySQL query will show multiple ways to use DEGREES function.

-- MySQL DEGREES Function Example

-- Finding Degrees for Negative Value
SELECT DEGREES(-10.75) AS `Value in Degrees`;

-- Finding Degrees for Positive Value
SELECT DEGREES(2.67) AS `Value in Degrees`;

-- Degrees Example along with PI()
SELECT DEGREES(PI()) AS `Value in Degrees`;
SELECT DEGREES(PI()/2) AS `Value in Degrees`;
SELECT DEGREES(PI()/3) AS `Value in Degrees`;

-- Degree of string value
SELECT DEGREES('6.74') AS `Value in Degrees`;

-- Degrees Example on String
SELECT DEGREES('MySQL') AS `Value in Degrees`;

From the below screenshot you can see, we used DEGREES function on different values. Here, we assigned a new name to the result as ‘Value in Degrees’ using ALIAS Column.

and

MySQL DEGREES Example 2

In MySQL, DEGREES Numeric Function also allows you to find the degree values for the column data. In this example, we are going to find the equivalent degree values for all the records present in Service Grade column.

-- MySQL DEGREES Function Example
USE mysqltutorial;
SELECT Product, Color,
		StandardCost, Sales, TaxAmt,
        ServiceGrade,
        DEGREES(ServiceGrade) AS `Grade Value in Degrees`
FROM `numeric functions`;

OUTPUT

Thank You for Visiting Our Blog