Date Field - 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
  • Days — Calculate the date difference in integer days.
  • Weeks — Either calculate the difference in days and convert this to fractional weeks, or express both dates in weeks and take the integer difference.
  • Months — Either calculate the difference in days and convert this to fractional months, or express both dates in months and take the integer difference.
  • Quarters — Either calculate the difference in days and convert this to fractional quarters, or express both dates in quarters and take the integer difference.
  • Years — Either calculate the difference in days and convert this to fractional years, or express both dates in years and take the integer difference.