div operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the integral part of the division of dividend by divisor.

Syntax 

dividend div divisor

Arguments

  • dividend: An expression that evaluates to a numeric or interval.

  • divisor: A matching interval type if dividend is an interval, a numeric otherwise.

Interval is supported since: Databricks Runtime 10.1

Returns

A BIGINT

If divisor is 0, INTERVAL '0' SECOND or INTERVAL '0' MONTH the operator raises a DIVIDE_BY_ZERO error.

Note

In Databricks Runtime, if spark.sql.ansi.enabled is false, the function returns NULL instead of a DIVIDE_BY_ZERO error.

Examples 

> SELECT 3 div 2;
 1
> SELECT -5.9 div 1;
 -5

> SELECT -5.9 div 0;
 Error: DIVIDE_BY_ZERO

> SELECT INTERVAL '100' HOUR div INTERVAL '1' DAY;
 4