date & time between

[jestin]

hi friends
I have a table which is dealing Date and Time.

the details is as follows

RequstId ReqDat StartTime End Time
1000 4/16/2008 7:30:00 AM 8:00:00 AM
1001 4/16/2008 8:00:00 AM 8:30.00 AM
1002 4/16/2008 8:30:00 AM 9:00:00 AM

and i am using Oracle8i as my db.

Friends what i need from u is that, i want to get a Requstid (for example 1001) in 04/16/2008 Between 8:00:00 am and 8:30:00 AM.

can u help me to write a query for this situation

[debasisdas]

Kindly post the query that you are working on, for further discussion on the topic.