Oracle SQL Query> Collect certian time intervatal data

[Ray Kim]

Oracel SQL Query
Collect a certain time intervatal data

I'm looking for queries to collect a certain time interval data from my table.
Here is current the data in my table and as you can see, the data is set with every 5 minute.

Time Load
06/14/2011 17:45:00 2,560
06/14/2011 17:50:00 2,422
06/14/2011 17:55:00 2,348
06/14/2011 18:00:00 2,765
06/14/2011 18:05:00 2,765


However, I need to mine quater hour data in 15 minutes time interval from avobe table as below.
Time Load
06/14/2011 17:45:00 2,560
06/14/2011 18:00:00 2,765
06/14/2011 18:15:00 2,342
06/14/2011 18:30:00 2,563


Would you let me know how I can collect the time interval data from my table?

[debasisdas]

How you retrieved the 1st dataset with five minutes interval ?

[Rabbit]

If you take the minute part of the time, and if the mod 15 of that is 0 then it's a quarter hour.