COS
The COS
function returns the cosine of Expression
(an angle expressed in radians).
SQL syntax
COS(Expression)
Parameters
COS
has the parameter:
Parameter | Description |
---|---|
|
Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type. |
Description
-
If
Expression
is of typeNUMBER
, the data type returned isNUMBER
. For all other numeric data types, the data type returned isBINARY_DOUBLE
. -
If the value of
Expression
isNULL
,NULL
is returned.
Example
Use the COS
function to return the cosine of 180
degrees.
Command> SELECT COS(180 * 3.14159265359/180) "Cosine of 180 degrees" FROM dual; < -.99999999999999999999999997862483333497 > 1 row found.