easy Q howto select between hrs & mins ?

Hi

Simple Question.

What is the quickest way to select using to_char from data_time mins/second where date_time is more than x date_time mins/seconds)

ie I have a large table that contains many records per day, displaying the times is easy but selecting only unique times between time1 and time2 (DDMONYY HH24:MM:SS) is harder any ideas on a query that will not impact the performance to hard on a large realtime system ?

Regards

Matt Received on Tue Jun 06 2000 - 00:00:00 CDT