Home / InterSystems SQL Reference / SQL Functions / COS

InterSystems SQL Reference
Previous section           Next section
InterSystems: The power behind what matters   

A scalar numeric function that returns the cosine, in radians, of an angle.
{fn COS(numeric-expression)}
numeric-expression A numeric expression. This is an angle expressed in radians.
COS returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, COS returns DOUBLE; otherwise, it returns NUMERIC.
COS takes any numeric value and returns the cosine as a floating point number. The returned value is within the range -1 to 1, inclusive. COS returns NULL if passed a NULL value. COS treats nonnumeric strings as the numeric value 0.
COS returns a value with a precision of 19 and a scale of 18.
COS can only be used as an ODBC scalar function (with the curly brace syntax).
You can use the DEGREES function to convert radians to degrees. You can use the RADIANS function to convert degrees to radians.
These examples show the effect of COS on two sines.
SELECT {fn COS(0.52)} AS Cosine
returns 0.86781.
SELECT {fn COS(-.31)} AS Cosine 
returns 0.95233.
See Also

Previous section           Next section
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-10 14:45:57