All mathematical functions have the following behaviors:
- They return
NULLif any of the input parameters is
Modulo function: returns the remainder of the division of X by Y. Returned value has the same sign as X.
Returns the smallest integral value (with FLOAT64 type) that is not less than X.
Synonym of CEIL(X)
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: