2141 Mathematical Functions Name Description ATAN() Return the arc tangent ATAN2() ,  ATAN() Return the arc tangent of the two arguments CEIL() Return the smallest integer value not less than the argument CEILING() Return the smallest integer value not less than the argument CONV() Convert numbers between different number bases COS() Return the cosine COT() Return the cotangent CRC32() Compute a cyclic redundancy check value DEGREES() Convert radians to degrees EXP() Raise to the power of FLOOR() Return the largest integer value not greater than the argument LN() Return the natural logarithm of the argument LOG() Return the natural logarithm of the first argument LOG10() Return the base-10 logarithm of the argument LOG2() Return the base-2 logarithm of the argument MOD() Return the remainder PI() Return the value of pi POW() Return the argument raised to the specified power POWER() Return the argument raised to the specified power RADIANS() Return argument converted to radians RAND() Return a random floating-point value ROUND() Round the argument SIGN() Return the sign of the argument SIN() Return the sine of the argument SQRT() Return the square root of the argument TAN() Return the tangent of the argument TRUNCATE() Truncate to specified number of decimal places All mathematical functions return  NULL  in the event of an error. • ABS( X ) mysql>  SELECT ABS(2); -> 2 mysql>  SELECT ABS(-32); Returns the absolute value of  X , or  NULL  if  X  is  NULL . The result type is derived from the argument type. An implication of this is that ABS(-9223372036854775808)  produces an error because the result cannot be stored in a signed BIGINT  value.