Date Field - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.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.