FDIV_SAFE

Syntax

FDIV_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.

Argument types:

  • numerator — Fractional number | Integer
  • denominator — Fractional number | Integer
  • fallback_value — Fractional number | Integer

Return type: Fractional number

Example

[numerator] [denominator] FDIV_SAFE([numerator], [denominator]) FDIV_SAFE([numerator], [denominator], 42)
5.00 2.00 2.50 2.50
5.00 0.00 NULL 42.00

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
EXP
Next
FLOOR