mysql
Khóa học miễn phí MySQL – Numeric Functions nhận dự án làm có lương
MySQL – Numeric Functions
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 |
Returns the absolute value of numeric expression. |
| 2 |
Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1. |
| 3 |
Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1 |
| 4 |
Returns the arctangent of numeric expression. |
| 5 |
Returns the arctangent of the two variables passed to it. |
| 6 |
Returns the smallest integer value that is not less than passed numeric expression |
| 7 |
Returns the smallest integer value that is not less than passed numeric expression |
| 8 |
Converts numeric expression from one base to another. |
| 9 |
Returns the cosine of passed numeric expression. The numeric expression should be expressed in radians. |
| 10 |
Returns the cotangent of passed numeric expression. |
| 11 |
Returns the Cyclic Redundancy Check (CRC) for the given value. |
| 12 |
Returns numeric expression converted from radians to degrees. |
| 13 |
Returns the base of the natural logarithm (e) raised to the power of passed numeric expression. |
| 14 |
Returns the largest integer value that is not greater than passed numeric expression. |
| 15 |
Returns a numeric expression rounded to a number of decimal places. |
| 16 |
returns the hexadecimal representation of the given value. |
| 17 |
Returns the natural logarithm of the passed numeric expression. |
| 18 |
Returns the natural logarithm of the passed numeric expression. |
| 19 |
Returns the base-10 logarithm of the passed numeric expression. |
| 20 |
Returns the base-2 logarithm of the passed numeric expression. |
| 21 |
Returns the remainder of one expression by diving by another expression. |
| 22 |
Returns the value of pi |
| 23 |
Returns the value of one expression raised to the power of another expression |
| 24 |
Returns the value of one expression raised to the power of another expression |
| 25 |
Returns the value of passed expression converted from degrees to radians. |
| 26 |
Returns a random floating-point value with in the range 0 to 1.0. |
| 27 |
Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points |
| 28 |
Returns the sign of the given number. |
| 29 |
Returns the sine of numeric expression given in radians. |
| 30 |
Returns the non-negative square root of numeric expression. |
| 31 |
Returns the tangent of numeric expression expressed in radians. |
| 32 |
Returns numeric exp1 truncated to exp2 decimal places. If exp2 is 0, then the result will have no decimal point. |
Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc
