skip to main content
Supported SQL Functionality and Extensions : 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 20. Numeric Operators
Entry SQL Level Operator
HiveQL Operator
N/A
% (Mod)
N/A
& (bitwise AND)
*
Supported
+
Supported
-
Supported
/
Supported
N/A
^ (XOR)