TRY_DIVIDE

​

Syntax

​

Scalar

try_divide(dividend, divisor)

​

Arguments

​

Returns

• Type: DOUBLE
• Possible values: The floating-point quotient.
• NULL behavior: Returns NULL for a NULL operand or either positive or negative zero divisor.

​

Properties

• Approximation bound: No fixed maximum error is guaranteed.

​

Usage notes

• Both operands are converted to DOUBLE before calculation.
• Floating-point overflow and NaN are ordinary floating-point results; TRY_DIVIDE does not replace all non-finite values with NULL.
• INTEGER and INT mean the same type; STRING means VARCHAR text. NULL can be used with a supported type. Cast NULL explicitly when its type would otherwise be unclear.
• Exact result: Floating-point computation can round the mathematical result.

​

Examples

​

Value and NULL input

SELECT try_divide(CAST(10 AS DOUBLE), CAST(4 AS DOUBLE)) AS quotient, try_divide(CAST(10 AS DOUBLE), CAST(0 AS DOUBLE)) AS zero_divisor, try_divide(CAST(NULL AS DOUBLE), CAST(2 AS DOUBLE)) AS null_value;

​

Decimal division

SELECT try_divide(CAST(7.5 AS DECIMAL(8,2)), CAST(2 AS DECIMAL(8,2))) AS quotient;