Add Months (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This function is only available when connected to a Teradata database.

The non-standard Teradata specific Add Months function is supported, generating ADD_MONTHS (date or timestamp expression, integer expression for months). The type of the value returned is the same as the type of the date or timestamp expression that months are added to or subtracted from. When dragging an Add Months function into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Date and Time > Add Months

Columns and/or other expressions and/or literals that resolve to a date can be moved over the first (empty) branch of the tree, while columns and/or expressions and/or literals that resolve to type integer can be moved over the second (empty) branch of the tree.

There are no special properties for the Add Months function.