radians function

The radians function converts the specified expression from degrees to radians.

Syntax:

double radians(n)

Semantics:

• n: The argument n is expressed in degrees. Here, n is an expression that resolves to a number.

• return type: double.

  • Returns a NULL value in the following cases:

    • n resolves to a NULL value

    • n does not resolve to a number

  • Returns NaN if n resolves to NaN.

  • Returns respective infinity if n resolves to positive/negative infinity.

Note:

The conversion from degrees to radians does not generally return an exact value. For example, consider the query:

SELECT cot(radians(90)) COT90 FROM Archery

The degrees to radians conversion results in: {"COT90":6.123233995736766E-17}

Example 1 - radians function

SELECT radians(n) FROM Archery

Value of n	Output
180	3.141592653589793
0	0.0