Add - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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. Refer to the chapter titled Binary Arithmetic Result Data Types in SQL Functions, Operators, Expressions and Predicates, B035-1145, for information on the resulting data types and other specific usage information. When dragging an Add into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Arithmetic > Add

Columns and/or other expressions can be moved over the (empty) branches of the tree.

There are no special properties for the Add function.