Numeric Functions

Functions dealing with numerals, including ABS, CEIL, DIV, EXP, PI, SIN, etc.

Title Description
Addition Operator (+) Addition.
Subtraction Operator (-) Subtraction and unary minus.
Division Operator (/) Division.
Multiplication Operator (*) Multiplication.
Modulo Operator (%) Modulo operator. Returns the remainder of N divided by M.
DIV Integer division.
ABS Returns an absolute value.
ACOS Returns an arc cosine.
ASIN Returns the arc sine.
ATAN Returns the arc tangent.
ATAN2 Returns the arc tangent of two variables.
CEIL Synonym for CEILING().
CEILING Returns the smallest integer not less than X.
CONV Converts numbers between different number bases.
COS Returns the cosine.
COT Returns the cotangent.
CRC32 Computes a cyclic redundancy check value.
DEGREES Converts from radians to degrees.
EXP e raised to the power of the argument.
FLOOR Largest integer value not greater than the argument.
GREATEST Returns the largest argument.
LEAST Returns the smallest argument.
LN Returns natural logarithm.
LOG Returns the natural logarithm.
LOG10 Returns the base-10 logarithm.
LOG2 Returns the base-2 logarithm.
MOD Modulo operation. Remainder of N divided by M.
OCT Returns octal value.
PI Returns the value of π (pi).
POW Returns X raised to the power of Y.
POWER Synonym for POW().
RADIANS Converts from degrees to radians.
RAND Random floating-point value.
ROUND Rounds a number.
SIGN Returns 1, 0 or -1.
SIN Returns the sine.
SQRT Square root.
TAN Returns the tangent.
TRUNCATE The TRUNCATE function truncates a number to a specified number of decimal places.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.