Numeric Functions
Functions dealing with numerals, including ABS, CEIL, DIV, EXP, PI, SIN, etc.
-
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 (CRC) value. -
CRC32C
Computes a cyclic redundancy check (CRC) value using the Castagnoli polynomial. -
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.
