The standard Subtract (-) operator is supported, generating expression - expression. Within Teradata, this operator automatically converts 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 subtracting an integer number of days from 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 a Subtract into a variable, the following tree element is created.
Columns and/or other expressions can be moved over the (empty) branch of the tree.
There are no special properties for the Subtract function.