Integer division

Divides two integers and truncates the result toward zero.

Category: binary

SQL symbol: DIV

Syntax

<dividend> DIV <divisor>

Parameters

• <dividend> — The integer to divide. Accepts integer.
• <divisor> — The integer to divide by. Accepts integer.

Returns

integer

Examples

SELECT 7 DIV 2, -7 DIV 2;

3 | -3

Signatures

• integer DIV integer → integer

Notes

Truncation is toward zero, not toward minus infinity: -7 DIV 2 is -3, where a floor division would give -4.

See Also

• Division /
• Modulo %