Numeric Functions

Returns the arc cosine of x, that is, the value whose cosine is x. Returns NULL if x is not in the range -1 to 1.

Returns the arc sine of x, that is, the value whose sine is x. Returns NULL if x is not in the range -1 to 1.

Returns the arc tangent of x, that is, the value whose tangent is x.

Returns the arc tangent of the two variables x and y. It is similar to calculating the arc tangent of y / x, except that the signs of both arguments are used to determine the quadrant of the result.

CEIL() is a synonym for CEILING().

Returns the smallest integer value not less than x.

Returns the cosine of x, where x is given in radians.

Returns the cotangent of x, where x is given in radians.

Returns the CRC32 checksum of a string.

Returns the argument x, converted from radians to degrees.

Returns the value of e (the base of natural logarithms) raised to the power of x.

Returns the largest integer value not greater than x.

Returns the value of pi as a floating-point value.

Returns the value of x raised to the power of y.

Returns the argument X, converted from degrees to radians.

Returns a random floating-point value v in the range 0 <= v < 1.0.

Rounds the argument X to D decimal places.

Returns the sign of the argument as -1, 0, or 1, depending on whether X is negative, zero, or positive or NULL if the argument was NULL.

Returns the sine of x, where x is given in radians.

Returns the square root of a nonnegative number x.

Returns the tangent of x, where x is given in radians.

Returns the number X, truncated to D decimal places.