DateTime
Language Issues
Special Character
Operators
The
following operators are special characters common to SQL and most
programming languages:
BinaryOperations
These
binary operations are available:
+ Add (for compatibility with SQL string concatenation
may also be defined using “||”)
- Subtract
* Multiply
/ Divide
UnaryOperations
These
unary operation are available:
- Negate
Comparison Operations
These comparison operations are available:
= EqualTo (EQ)
<> NotEqualTo (NE)
> GreaterThan (GT)
>= GreaterThanOrEqualTo (GE)
< LessThan (LT)
<= LessThanOrEqualTo (LE)
Operator Precedence
The following precedence is shown from highest
to lowest:
Negate NOT
Multiply Divide
Add Subtract
EQ NE GT GE LT LE
AND
OR