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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
{ { 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.