Categories:

Numeric functions (Trigonometric)

DEGREES¶

Converts radians to degrees.

Syntax¶

DEGREES( <input_expr> )
Copy

Arguments¶

input_expr

The value or expression to operate on. The data type must be FLOAT or DECFLOAT.

Returns¶

If the input expression is of type DECFLOAT, the returned type is DECFLOAT. Otherwise, the returned type is FLOAT.

Examples¶

Show the number of degrees for 1/3 of a radian, 1 radian, and 3 radians:

SELECT DEGREES(PI()/3), DEGREES(PI()), DEGREES(3 * PI()), DEGREES(1);
+-----------------+---------------+-------------------+--------------+
| DEGREES(PI()/3) | DEGREES(PI()) | DEGREES(3 * PI()) |   DEGREES(1) |
|-----------------+---------------+-------------------+--------------|
|              60 |           180 |               540 | 57.295779513 |
+-----------------+---------------+-------------------+--------------+
Copy