16.20 - Result Value - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)
Function Result Value
COS(arg) The cosine of arg in radians in the range -1 to 1, inclusive.
SIN(arg) The sine of arg in radians in the range -1 to 1, inclusive.
TAN(arg) The tangent of arg in radians.
ACOS(arg) An angle in the range 0 to π radians, inclusive.
ASIN(arg) An angle in the range -π /2 to π /2 radians, inclusive.
ATAN(arg) An angle in the range -π /2 to π /2 radians, inclusive.
ATAN2(x,y) 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.