List of operators and operand data types.
|
Operator |
Result |
Operands |
|---|---|---|
|
+, - (as unary operators) |
Integer |
Integer |
|
+, - (as unary operators) |
Long |
Long |
|
+, - (as unary operators) |
Float |
Float |
|
+, - (as unary operators) |
Interval |
Interval |
|
+,-,*, /, mod |
Integer |
Integer, Integer |
|
+,-,*, /, mod |
Long |
Long, Long |
|
+,-,*, /, ^, mod |
Float |
Float, Float |
|
+ |
BLOB |
BLOB |
|
^ |
Float |
Integer, Float |
|
^ |
Float |
Long, Float |
|
+,-,mod |
Interval |
Interval, Interval |
|
/ |
Float |
Interval, Interval |
|
+ |
Timestamp |
Interval, Timestamp |
|
*,/ |
Interval |
Interval, Integer |
|
*,/ |
Interval |
Interval, Long |
|
*,/ |
Interval |
Interval, Float |
|
- |
Interval |
Timestamp, Timestamp |
|
+,- |
Timestamp |
Timestamp, Interval |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Boolean, Boolean |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Integer, Integer |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Long, Long |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Float, Float |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Interval, Interval |
|
=, !=, <>, <, >, <=, >= |
Boolean |
String, String |
|
=, !=, <>, <, >, <=, >= |
Boolean |
Timestamp, Timestamp |
|
=, !=, <>, <, >, <=, >= |
Boolean |
BLOB |
|
NOT |
Boolean |
Boolean |
|
AND, OR, XOR |
Boolean |
Boolean, Boolean |
|
IN |
Boolean |
Boolean, Boolean |
|
IN |
Boolean |
Float, Float |
|
IN |
Boolean |
Integer, Integer |
|
IN |
Boolean |
Long, Long |
|
IN |
Boolean |
Interval, Interval |
|
IN |
Boolean |
String, String |
|
IN |
Boolean |
Timestamp, Timestamp |
|
||, + |
String |
String, String |
|
[ ]. (previous operator) |
Boolean |
Integer, Boolean |
|
[ ]. (previous operator) |
Float |
Integer, Float |
|
[ ]. (previous operator) |
Integer |
Integer, Integer |
|
[ ]. (previous operator) |
Long |
Integer, Long |
|
[ ]. (previous operator) |
String |
Integer, String |
|
[ ]. (previous operator) |
Interval |
Integer, Interval |
|
[ ]. (previous operator) |
Timestamp |
Integer, Timestamp |
|
[ ]. (previous operator) |
BLOB |
Integer, BLOB |
|
[ ]. (previous operator) |
XML |
Integer, XML |
|
LIKE |
Boolean |
String, String |
|
REGEXP_LIKE |
Boolean |
String, String |
Note that you cannot divide a TIMESTAMP by an INTERVAL, and you cannot use an expression of the form TIMESTAMP mod INTERVAL.