ASIN function
Derby Reference Manual
113
· If the specified number is NULL, the result of this function is NULL.
· If the absolute value of the specified number is greater than 1, an exception is
returned that indicates that the value is out of range (SQL state 22003).
The returned value, in radians, is in the range of zero (0) to pi. The data type of the
returned value is a DOUBLE PRECISION number.
Syntax
ACOS ( number )
ASIN function
The ASIN function returns the arc sine of a specified number.
The specified number is the sine, in radians, of the angle that you want. The specified
number must be a
number.
· If the specified number is NULL, the result of this function is NULL.
· If the specified number is zero (0), the result of this function is zero with the same
sign as the specified number.
· If the absolute value of the specified number is greater than 1, an exception is
returned that indicates that the value is out of range (SQL state 22003).
The returned value, in radians, is in the range -pi/2 to pi/2. The data type of the returned
value is a DOUBLE PRECISION number.
Syntax
ASIN ( number )
ATAN function
The ATAN function returns the arc tangent of a specified number.
The specified number is the tangent, in radians, of the angle that you want. The specified
number must be a
number.
· If the specified number is NULL, the result of this function is NULL.
· If the specified number is zero (0), the result of this function is zero with the same
sign as the specified number.
The returned value, in radians, is in the range -pi/2 to pi/2. The data type of the returned
value is a DOUBLE PRECISION number.
Syntax
ATAN ( number )
ATAN2 function
The ATAN2 function returns the arctangent, in radians, of the quotient of the two
arguments.
Upon successful completion, the function returns the arc tangent of y/x in the range -pi
to pi radians, where y is the first argument and x is the second argument. The specified
numbers must be
numbers.
· If either argument is NULL, the result of the function is NULL.
· If the first argument is zero and the second argument is positive, the result of the
function is zero.
· If the first argument is zero and the second argument is negative, the result of the
function is the double value closest to pi.
