Function call rules in Dataflow SQL

The following rules apply to all functions unless explicitly indicated otherwise in the function description:

  • For functions that accept numeric types, if one operand is a floating point operand and the other operand is another numeric type, both operands are converted to FLOAT64 before the function is evaluated.

  • If an operand is NULL, the result is NULL, except for the IS operator.

  • For functions that are time zone sensitive (indicated in the function description), if a time zone is not specified, the default time zone is used. UTC is the default time zone.