DIV_SAFE

Syntax

DIV_SAFE( numerator, denominator [ , fallback_value ] )

Description

Divides numerator by denominator. Returns fallback_value if division by zero occurs. If the number fallback_value is omitted, it is assumed to be NULL.
The result is rounded down to the nearest integer.

Argument types:

  • numeratorFractional number | Integer
  • denominatorFractional number | Integer
  • fallback_valueInteger

Return type: Integer

Example

[numerator] [denominator] DIV_SAFE([numerator], [denominator]) DIV_SAFE([numerator], [denominator], 42)
5.00 2.00 2 2
5.00 0.00 NULL 42

Data source support

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Previous
Next