Skip to main content

Month-Year Difference Determination UDF

Details


These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference. According to the ANSI SQL standard, units smaller than the unit of the result are to be ignored in an SQL calculation, but this can lead to results not consistent with business practices (Refer to NTA 1553). This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.

Not available
OS version
1.0
Release version

Technical Details

  • Version
  • Released
  • TTU
  • OS
  • Teradata

Month-Year Difference Determination UDF