skip to main content
Supported SQL Functionality : SQL Expressions : Numeric Operators
  

Try DataDirect Drivers Now

Numeric Operators

You can use a numeric operator in an expression to negate, add, subtract, multiply, and divide numeric values. The result of this operation is also a numeric value. The + and - operators are also supported in date/time fields to allow date arithmetic.
The following table lists the supported arithmetic operators.
Table 21. Numeric Operators
Entry SQL Level Operator
Spark SQL Operator
*
Supported
+
Supported
-
Supported
/
Supported
^ (XOR)
N/A
% (Mod)
N/A
& (bitwise AND)
N/A