A Teradata Warehouse Miner specific function is provided for calculating the date/time differences between two Timestamp columns in seconds, minutes, hours or days. Note that this includes the day differences as well as the time differences. All the measures are based on the difference measured in seconds, with conversions to other larger units. Any differences in time zones are ignored. When dragging a Date/Time Difference 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) branches of the tree.
The difference in seconds, minutes, hours and days are set through the Properties panel. Double-click on Date/Time Difference, or highlight it and click Properties.
Select Seconds, Minutes, Hours or Days from the Time Field pull-down.