Skip to main content
VeloDB Cloud 4.x·Apache Doris 3.x·"Since X.Y" tags refer to Doris versionsversion mapping →

FMOD

Description​

Find the remainder of a / b for the floating-point type. For the integer type, please use the mod function.

Syntax​

MOD(<col_a> , <col_b>)

Parameters​

ParameterDescription
<col_a>Dividend
<col_b>Divisor should not be 0

Return value​

Return a float-point type. Special cases:

If col_a IS NULL or col_b IS NULL, return NULL.

Example​

select fmod(10.1, 3.2);
+--------------------+
| fmod(10.1, 3.2)    |
+--------------------+
| 0.4999999999999991 |
+--------------------+
select fmod(10.1, 0);
+---------------+
| fmod(10.1, 0) |
+---------------+
|          NULL |
+---------------+