Archives of the TeradataForum

Message Posted: Mon, 29 Oct 2012 @ 22:08:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The OVERLAPS function returns "true" only when the entire first range is "inside" the second range.

See chapter 9 of the "SQL Functions, Operators, Expressions, and Predicates" manual. It shows that this function:

     (S1, E1) OVERLAPS (S2, E2)

Is equivalent to:

     (S1 > S2 AND NOT (S1 >= E2 AND E1 >= E2))
     OR
     (S2 > S1 AND NOT (S2 >= E1 AND E2 >= E1))
     OR
     (S1 = S2 AND (E1 = E2 OR E1 <> E2))

	<Prev	Next>		<<First	<Prev	Next>	Last>>