The standard Add (+) operator is supported, generating expression + expression. Within Teradata, these operators automatically convert numeric operands to the expected result type before they are applied. Character type data is converted to FLOAT if possible before being applied. Operands of type DATE are valid, when adding an integer number of days to a date expression. For information on the resulting data types and other specific usage like binary arithmetic result data types, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145. When dragging an Add into a variable, the following tree element is created.
Columns and/or other expressions can be moved over the (empty) branches of the tree.
There are no special properties for the Add function.