Mega Code Archive

 

Categories / MySQL Tutorial / Math Numeric Functions

 

Numeric Functions

Name Description ABS()Return the absolute value ACOS()Return the arc cosine ASIN()Return the arc sine ATAN2(), ATAN()Return the arc tangent of the two arguments ATAN()Return the arc tangent CEILING(), CEIL()Return the smallest integer value not less than the argument 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 LOG10()Return the base-10 logarithm of the argument LOG2()Return the base-2 logarithm of the argument LOG()Return the natural logarithm of the first argument MOD()Return the remainder PI()Return the value of pi POW(), 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 Quote: dev.mysql.com/doc/refman/5.1/en/index.html