TRIGONOMETRIC Function Syntax | Teradata Vantage - TRIGONOMETRIC Function Syntax - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™
{ { COS | SIN | TAN | ACOS | ASIN | ATAN } (arg) |
  ATAN2 (x, y)
}

Syntax Elements

COS
Cosine. The cosine of an angle is the ratio of two sides of a right triangle. The ratio is the length of the side adjacent to the angle divided by the length of the hypotenuse.
COS (arg) is a value in radians in the range -1 to 1, inclusive.
SIN
Sine. The sine of an angle is the ratio of two sides of a right triangle. The ratio is the length of the side opposite to the angle divided by the length of the hypotenuse.
SIN (arg) is a value in radians in the range -1 to 1, inclusive.
TAN
Tangent. The tangent of an angle is the ratio of two sides of a right triangle. The ratio is the length of the side opposite to the angle divided by the length of the side adjacent to the angle.
TAN (arg) is a value in radians.
ACOS
Arccosine. The arccosine is the angle whose cosine is the argument.
ACOS (arg) is an angle in the range 0 to π radians, inclusive.
ASIN
Arcsine. The arcsine is the angle whose sine is the argument.
ASIN (arg) is an angle in the range -π /2 to π /2 radians, inclusive.
ATAN
Arctangent. The arctangent is the angle whose tangent is the argument.
ATAN (arg) is an angle in the range -π /2 to π /2 radians, inclusive.
ATAN2
ATAN2 (arg) is an angle between -π and π radians, excluding -π.
A positive result represents a counterclockwise angle from the x-axis. A negative result represents a clockwise angle.
ATAN2(x,y) equals ATAN(y/x), except that x can be 0 in ATAN2(x,y) and x cannot be 0 in ATAN(y/x) since this results in a divide by zero error.
If both x and y are 0, an error is returned.
arg
Any valid numeric expression that expresses an angle in radians.
x
The x-coordinate of a point to use in the arctangent2 calculation.
y
The y-coordinate of a point to use in the arctangent2 calculation.