Archives of the TeradataForum
Message Posted: Wed, 04 Jun 2008 @ 16:09:20 GMT
<-- Anonymously Posted: Wed, 4 Jun 2008 10:02 -->
Excerpts from Tech Alert# NTA 1553
The above can pose problems for customers that were relying on the prior behavior. While there are a number of ways around this
issue using SQL, the cleanest solution is a UDF.
Sel (DATE '2007-05-10' - DATE '2007-04-28')Month;
Returns 0 prior to DR96278 (because the difference is not a "full month"), but returns 1 after the fix is applied.
The Tech Alert in T@YS also has sample UDF code attached.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|