Result Value

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K
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.