RADIANS (SQL)
A numeric function that converts degrees to radians.
Synopsis
RADIANS(numeric-expression) {fn RADIANS(numeric-expression)}
Arguments
| Argument | Description |
|---|---|
| numeric-expression | The measure of an angle in degrees. An expression that resolves to a numeric value. |
RADIANS returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, RADIANS returns DOUBLE; otherwise, it returns NUMERIC.
RADIANS can be specified as either a standard scalar function or an ODBC scalar function with curly brace syntax.
Description
RADIANS takes an angle measurement in degrees and returns the corresponding angle measurement in radians. RADIANS 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 DEGREES function to convert radians to degrees.
Example
The following Embedded SQL example returns the radians equivalents corresponding to the degree values from 0 through 365 in 30-degree increments:
SET a=0
WHILE a<366 {
&sql(SELECT RADIANS(:a) INTO :b)
IF SQLCODE'=0 {
WRITE !,"Error code ",SQLCODE
QUIT }
ELSE {
WRITE !,"degrees ",a," = radians ",b
SET a=a+30 }
}
