Arithmetic Operators

The 4GL arithmetic operators perform arithmetic operations on operands of number data types (and in some cases, of time data types).

This is the syntax for arithmetic expressions that return a number value:

4GLREF00000060.gif

This is the syntax for arithmetic expressions that return a DATE value:

4GLREF00000061.gif

This is the syntax for arithmetic expressions that return a DATETIME value:

4GLREF00000062.gif

This is the syntax for arithmetic expressions that return an INTERVAL value:

4GLREF00000063.gif

If any component of an expression that includes an arithmetic operator is a NULL value, then the entire expression returns NULL, unless the NULL value is an operand of the IS NULL or IS NOT NULL keywords.

References

Aggregate Report Functions

Boolean Operators

EXTEND( )

UNITS