Archives of the TeradataForum
Message Posted: Wed, 31 Oct 2012 @ 21:07:06 GMT
don't mess with Standard SQL :-)
This formula is directly copied from the standards and there are some more rules, i doubt you can prove it's wrong:
4) If D1 is the null value or if E1 < D1, then let S1 = E1 and let T1 = D1. Otherwise, let S1 = D1 and let T1 = E1.
a) If the most specific type of the second field of
b) If the most specific type of the second field of
6) If D2 is the null value or if E2 < D2, then let S2 = E2 and let T2 = D2. Otherwise, let S2 = D2 and let T2 = E2.
7) The result of the
( S1 > S2 AND NOT ( S1 >= T2 AND T1 >= T2 ) ) OR ( S2 > S1 AND NOT ( S2 >= T1 AND T2 >= T1 ) ) OR ( S1 = S2 AND ( T1 <> T2 OR T1 = T2 ) )
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|