Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

SIN (SQL)

A scalar numeric function that returns the sine, in radians, of an angle.

Synopsis

{fn SIN(float-expression)}

Arguments

Argument Description
float-expression An expression of type FLOAT. This is an angle expressed in radians.

Description

SIN takes any numeric value and returns its sine as a floating point number. SIN returns NULL if passed a NULL value. SIN treats nonnumeric strings as the numeric value 0.

SIN returns a value of data type FLOAT with a precision of 19 and a scale of 18.

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

Example

The following example shows the effect of SIN:

SELECT {fn SIN(0.52)} AS Sine

returns 0.496880.

See Also

Feedback