Categories:

Numeric Functions

# DIV0¶

Performs division like the division operator (/), but returns 0 when the divisor is 0 (rather than reporting an error).

DIV0NULL

## Syntax¶

DIV0( <dividend> , <divisor> )


## Arguments¶

dividend

Numeric expression that evaluates to the value that you want to divide.

divisor

Numeric expression that evaluates to the value that you want to divide by.

## Returns¶

The quotient. If the divisor is 0, the function returns 0.

## Examples¶

As shown in the following example, the DIV0 function performs division like the division operator (/):

SELECT 1/2;
+----------+
|      1/2 |
|----------|
| 0.500000 |
+----------+
SELECT DIV0(1, 2);
+------------+
| DIV0(1, 2) |
|------------|
|   0.500000 |
+------------+


Unlike the division operator, DIV0 returns a 0 (rather than reporting an error) when the divisor is 0.

select 1/0;
100051 (22012): Division by zero

SELECT DIV0(1, 0);
+------------+
| DIV0(1, 0) |
|------------|
|   0.000000 |
+------------+