Archives of the TeradataForum

Message Posted: Thu, 26 Oct 2006 @ 21:03:37 GMT

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

Try this

     select * from some_table A
     where (A.start_time, A.end_time) overlaps (cast('2006-10-26 07:00:00' as
     timestamp)+ INTERVAL '00 00:00:00' DAY TO SECOND,cast('2006-10-26
     07:00:00' as timestamp)+ INTERVAL '00 00:00:01' DAY TO SECOND)

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