DIVINT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Return the integer value of one number divided by another.
USAGE
DIVINT(dividend, divisor)
| The numbers in the division |
| The numbers in the division |
DETAILS
DIVINT() is a mathematical function that divides the dividend by the divisor and returns the integer result of the division with any decimal places truncated from the value. The DIVINT() function is similar to the DIV operator.
A NULL is returned if the divisor is 0 or if either the dividend or divisor is NULL.
Because the returned value is not rounded down, the result of DIVINT(x, y) is not the same as FLOOR(DIVINT(x, y)) when the resulting value is negative.
To obtain the floating point result of a division operation, see "/" or "DIVFLT()".
EXAMPLES
SELECT DIVINT(12345, 10), DIVINT(22, 3), DIVINT(.5, .25);
+-------------------+---------------+-----------------+
| DIVINT(12345, 10) | DIVINT(22, 3) | DIVINT(.5, .25) |
+-------------------+---------------+-----------------+
| 1234 | 7 | 2 |
+-------------------+---------------+-----------------+
CREATE TABLE div_int_example (
val INT
);
INSERT INTO div_int_example VALUES
(21), (22), (23), (24), (25), (26), (27), (28),
(-21), (-22), (-23), (-24), (-25), (-26), (-27), (-28);
SELECT val, DIVINT(val, 7), val / 7, FLOOR(val / 7)
FROM div_int_example;
+------+----------------+---------+----------------+
| val | DIVINT(val, 7) | val / 7 | FLOOR(val / 7) |
+------+----------------+---------+----------------+
| 21 | 3 | 3.0000 | 3 |
| 22 | 3 | 3.1429 | 3 |
| 23 | 3 | 3.2857 | 3 |
| 24 | 3 | 3.4286 | 3 |
| 25 | 3 | 3.5714 | 3 |
| 26 | 3 | 3.7143 | 3 |
| 27 | 3 | 3.8571 | 3 |
| 28 | 4 | 4.0000 | 4 |
| -21 | -3 | -3.0000 | -3 |
| -22 | -3 | -3.1429 | -4 |
| -23 | -3 | -3.2857 | -4 |
| -24 | -3 | -3.4286 | -4 |
| -25 | -3 | -3.5714 | -4 |
| -26 | -3 | -3.7143 | -4 |
| -27 | -3 | -3.8571 | -4 |
| -28 | -4 | -4.0000 | -4 |
+------+----------------+---------+----------------+