Date - Teradata Warehouse Miner

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

Teradata Warehouse Miner
Release Number
November 2018
English (United States)
Last Update
Product Category

SQL Date literal parameter values consist of the keyword DATE followed by a date enclosed in single quotes with the format YYYY-MM-DD such as DATE ‘2003-12-31’. When dragging a literal Date parameter into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > Date

A default date of January 1, 0001 is provided, but can be changed via the Properties panel. Double-click on Date (1/1/0001) or highlight and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > Date Properties

  • Parameter — Either ‘<NewParameter>’ may be selected, or an existing parameter may be selected via the pull-down list.
  • Name — When ‘<NewParameter>’ is selected, the Name of the new parameter may be entered here. The name must be unique among all parameters defined in the analysis.
  • Description — A description of the parameter may be entered here. It should be limited to 512 characters if the analysis is ever to be published to the Model Manager application.
  • Date — Either the standard Windows Calendar control (reached by selecting the pull-down arrow of the selector) can be used to set the desired date by clicking through the months in the calendar using the < and > buttons, or the date can be set by just typing in the desired values for the month, day and year, one at a time.