Beam ZetaSQL mathematical functions

This page documents ZetaSQL scalar functions supported by Beam ZetaSQL.

All mathematical functions return NULL if any of the input parameters is NULL.

Operator syntax Description
MOD(X, Y) Returns the remainder of the division of X by Y
CEIL(X) Returns the smallest integral value (with FLOAT64 type) that is not less than X
CEILING(X) Synonym of CEIL(X)
FLOOR(X) Returns the largest integral value (with FLOAT64 type) that is not greater than X

MOD

MOD(X, Y)

Description

Modulo function: returns the remainder of the division of X by Y. Returned value has the same sign as X.

CEIL

CEIL(X)

Description

Returns the smallest integral value (with FLOAT64 type) that is not less than X.

CEILING

CEILING(X)

Description

Synonym of CEIL(X)

FLOOR

FLOOR(X)

Description

Returns the largest integral value (with FLOAT64 type) that is not greater than X.

Example rounding function behavior

Example behavior of Cloud Dataflow SQL rounding functions:

Input "X" CEIL(X) FLOOR(X)
2.0 2.0 2.0
2.3 3.0 2.0
2.8 3.0 2.0
2.5 3.0 2.0
-2.3 -2.0 -3.0
-2.8 -2.0 -3.0
-2.5 -2.0 -3.0
0 0 0