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 |
{:.table} |
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(X)
Description
Returns the smallest integral value (with FLOAT64 type) that is not less than X.
CEILING(X)
Description
Synonym of CEIL(X)
FLOOR(X)
Description
Returns the largest integral value (with FLOAT64 type) that is not greater than X.
Example behavior of Cloud Dataflow SQL rounding functions: