/ [division]

All functions > MATH > / [division]

Divides the left-hand number by the right-hand number, producing a DOUBLE result.

Syntax

left / right  ·  DIVIDE(left, right)

left / right  ·  DIVIDE(left, right)

Notes

• Both operands are promoted for division; the result type is DOUBLE
• Returns NULL if either operand is NULL
• Division by zero is an error; use TRY_DIVIDE for a NULL result when the divisor may be zero
• For type-preserving division (including integer truncation), use DIVIDE_TYPE (//)

Related Functions

• DIVIDE()

Examples

/ — floating-point division

SELECT
    f1 := 10E0 / 3E0, -- Quotient as DOUBLE
    f2 := 15E0 / 5E0 -- Exact division
;

/ — edge cases

SELECT
    f1 := -8E0 / 4E0 -- Negative dividend
;