Skip to main content

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. 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 }
   }

See Also

FeedbackOpens in a new tab