An expression can contain:
Operations '*','/' and unary '-' are acceptable for numeric operands only.
Only comparison operations can be applied to strings.
Logical operations '>','>=','<','<=','=','!=' are acceptable for numeric, date and time operands.
'&' and '|' are acceptable for logical (boolean) operands only. We recommend to use extra '(...)' for complex operands: "((a=1) | (b=2))" instead of "a=1 | b=2".
Right operand | ||||
---|---|---|---|---|
Left operand | Integer | Float | Date | Time |
Integer | + | + (float) | Add N days | Add N seconds |
Float | + (float) | + | N/A | N/A |
Date | add N days | N/A | N/A | N/A |
Time | add N seconds | N/A | N/A | N/A |
Right operand | ||||
---|---|---|---|---|
Left operand | Integer | Float | Date | Time |
Integer | - | - (float) | N/A | N/A |
Float | - (float) | + | N/A | N/A |
Date | subtract N days | N/A | N/A | N/A |
Time | subtract N seconds | N/A | - (int)^{*} | N/A |