MySQL Mathematical Functions
From w3cyberlearnings
| # | Function | Description |
|---|---|---|
| 1 | ABS | Return the absolute value |
| 2 | ACOS | Return the arc cosine |
| 3 | ASIN | Return the arc sine |
| 4 | ATAN2 | ATAN() Return the arc tangent of the two arguments |
| 5 | ATAN | Return the arc tangent |
| 6 | CEIL | Return the smallest integer value not less than the argument |
| 7 | CEILING | Return the smallest integer value not less than the argument |
| 8 | CONV | Convert numbers between different number bases |
| 9 | COS | Return the cosine |
| 10 | COT | Return the cotangent |
| 11 | CRC32 | Compute a cyclic redundancy check value |
| 12 | DEGREES | Convert radians to degrees |
| 13 | EXP | Raise to the power of |
| 14 | FLOOR | Return the largest integer value not greater than the argument |
| 15 | LN | Return the natural logarithm of the argument |
| 16 | LOG10 | Return the base-10 logarithm of the argument |
| 17 | LOG2 | Return the base-2 logarithm of the argument |
| 18 | LOG | Return the natural logarithm of the first argument |
| 19 | MOD | Return the remainder |
| 20 | OCT | Return an octal representation of a decimal number |
| 21 | PI | Return the value of pi |
| 22 | POW | Return the argument raised to the specified power |
| 23 | POWER | Return the argument raised to the specified power |
| 24 | RADIANS | Return argument converted to radians |
| 25 | RAND | Return a random floating-point value |
| 26 | ROUND | Round the argument |
| 27 | SIGN | Return the sign of the argument |
| 28 | SIN | Return the sine of the argument |
| 29 | SQRT | Return the square root of the argument |
| 30 | TAN | Return the tangent of the argument |
| 31 | TRUNCATE | Truncate to specified number of decimal places |
