Archives of the TeradataForum

Message Posted: Thu, 26 Oct 2006 @ 15:53:20 GMT

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

Emanuel:

You can do the following;

     sel 'overlaps'
     where cast((extract(hour from current_time)(format
     '99'))||':'||(extract(minute from current_time)(format '99')) as
     interval hour to minute)
        between cast(field1 as interval hour to minute)
         and    cast(field2 as interval hour to minute)

Just make sure that field1 is the earlier time based on a 24 hour clock.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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