A Teradata Warehouse Miner specific function is provided for calculating in various units the elapsed time from midnight represented by the time portion of a Timestamp or Time expression. Time zones are ignored. By default, the elapsed time is calculated in units of seconds, but may alternatively be requested in minutes, hours or days (fraction of a day). When dragging an Elapsed Time function into a variable, the following tree element is created.
Columns and/or other expressions/literals that resolve to a time or timestamp can be moved over the (empty) branch of the tree.
Options to compute the elapsed time in seconds, minutes, hours or days (fraction of a day) are set through the Properties panel. Double-click on Elapsed Time, or highlight it and click Properties.