Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. Creating Custom Functions
  8. Custom Function API Reference
  9. POWERCENTERHELP

Transformation Language Reference

Transformation Language Reference

SIN

SIN

Returns the sine of a numeric value (expressed in radians).

Syntax

SIN(
numeric_value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
numeric_value
Required
Numeric datatype. Numeric data expressed in radians (degrees multiplied by pi divided by 180). Passes the values for which you want to calculate the sine. You can enter any valid transformation expression. You can also use operators to convert a numeric value to radians or perform arithmetic within the SIN calculation.

Return Value

Double value.
NULL if a value passed to the function is NULL.

Example

The following expression converts the values in the Degrees port to radians and then calculates the sine for each radian:
SIN( DEGREES * 3.14159265359 / 180 )
DEGREES  
RETURN VALUE
0
0
90
1
70
0.939692620785936
30
0.50000000000003
5
0.0871557427476639
89
0.999847695156393
NULL
NULL
You can perform arithmetic on the values passed to SIN before the function calculates the sine. For example:
SIN( ARCS * 3.14159265359 / 180 )