”;
MySQL – Numeric Functions
MySQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions that are available in the MySQL.
| Sr.No. | Name & Description |
|---|---|
| 1 | ABS()
Returns the absolute value of numeric expression.
|
| 2 | ACOS()
Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1.
|
| 3 | ASIN()
Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1
|
| 4 | ATAN()
Returns the arctangent of numeric expression.
|
| 5 | ATAN2()
Returns the arctangent of the two variables passed to it.
|
| 6 | CEIL()
Returns the smallest integer value that is not less than passed numeric expression
|
| 7 | CEILING()
Returns the smallest integer value that is not less than passed numeric expression
|
| 8 | CONV()
Converts numeric expression from one base to another.
|
| 9 | COS()
Returns the cosine of passed numeric expression. The numeric expression should be expressed in radians.
|
| 10 | COT()
Returns the cotangent of passed numeric expression.
|
| 11 | CRC32()
Returns the Cyclic Redundancy Check (CRC) for the given value.
|
| 12 | DEGREES()
Returns numeric expression converted from radians to degrees.
|
| 13 | EXP()
Returns the base of the natural logarithm (e) raised to the power of passed numeric expression.
|
| 14 | FLOOR()
Returns the largest integer value that is not greater than passed numeric expression.
|
| 15 | FORMAT()
Returns a numeric expression rounded to a number of decimal places.
|
| 16 | HEX()
returns the hexadecimal representation of the given value.
|
| 17 | LN()
Returns the natural logarithm of the passed numeric expression.
|
| 18 | LOG()
Returns the natural logarithm of the passed numeric expression.
|
| 19 | LOG10()
Returns the base-10 logarithm of the passed numeric expression.
|
| 20 | LOG2()
Returns the base-2 logarithm of the passed numeric expression.
|
| 21 | MOD()
Returns the remainder of one expression by diving by another expression.
|
| 22 | PI()
Returns the value of pi
|
| 23 | POW()
Returns the value of one expression raised to the power of another expression
|
| 24 | POWER()
Returns the value of one expression raised to the power of another expression
|
| 25 | RADIANS()
Returns the value of passed expression converted from degrees to radians.
|
| 26 | RAND()
Returns a random floating-point value with in the range 0 to 1.0.
|
| 27 | ROUND()
Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points
|
| 28 | SIGN()
Returns the sign of the given number.
|
| 29 | SIN()
Returns the sine of numeric expression given in radians.
|
| 30 | SQRT()
Returns the non-negative square root of numeric expression.
|
| 31 | TAN()
Returns the tangent of numeric expression expressed in radians.
|
| 32 | TRUNCATE()
Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point.
|
”;