» Documentation » SQL Reference

Arithmetic Functions

ACOS

ACOS(number) 

Returns the arc cosine in radians between -π/2 to π/2 of the number given, which must lie between -1 and 1.

ASIN

ASIN(number) 

Returns the arc sine in radians between -π/2 to π/2 of the number given, which must lie between -1 and 1.

ATAN

ATAN(number) 

Returns the arc tangent in radians between -π/2 to π/2 of the number given, which must lie between -1 and 1.

ATAN2

ATAN2(y,x) 

Returns the arc tangent in radians between -?π to π of y/x. The result will be in the correct quadrant.

COS

COS(angle_radians) 

Returns the cosine of the angle given in radians.

SIN

SIN(angle_radians) 

Returns the sine of the angle given in radians.

TAN

TAN(angle_radians) 

Returns the tangent of the angle given in radians.