DEGREES (SQL)

A numeric function that converts radians to degrees.

Synopsis

DEGREES(numeric-expression)

{fn DEGREES(numeric-expression)}

Description

DEGREES takes an angle measurement in radians and returns the corresponding angle measurement in degrees. DEGREES returns NULL if passed a NULL value.

The returned value has a default precision of 36 and a default scale of 18.

You can use the RADIANS function to convert degrees to radians.

Arguments

numeric-expression

The name of the savepoint, specified as an identifier. For further details see the “Identifiers” chapter of Using InterSystems SQL.The measure of an angle in radians. An expression that resolves to a numeric value.

DEGREES returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, DEGREES returns DOUBLE; otherwise, it returns NUMERIC.

DEGREES can be specified as either a standard scalar function or an ODBC scalar function with curly brace syntax.

Examples

The following Embedded SQL example returns the degree equivalents corresponding to the radian values 0 through 6:

   SET a=0
   WHILE a<7 {
   &sql(SELECT DEGREES(:a) INTO :b)
   IF SQLCODE'=0 {
     WRITE !,"Error code ",SQLCODE
     QUIT }
   ELSE {
     WRITE !,"radians ",a," = degrees ",b
     SET a=a+1 }
   }