ATAN2 in Teradata

  1. Forget Code
  2. Teradata
  3. ATAN2

ATAN2 returns the arctangent of specified x and y coordinates and it is the extension to ANSI SQL-99.

Syntax:

SELECT ATAN2(x,y)


The returned angle is between -π and π radians, excluding -π.

Note: 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.

Example:

SEL ATAN2(1,1) 

 Result: 7.85398163397448E


..