Problem with date query - simple?

Greetings,

I'm trying to select records from a table based on a date field and can't seem to figure out how to set up variable date checking. This select statement is in a view so it needs to be able to determine the current time and then request either today's data or yesterday's. (All of this is on 8.1.7.2.5 under W2K)

Basically I want all records between a certain time (say 6 PM and 10 PM) from the nearest current time.

That is, if it's currently before 10 PM I want the data from last night, otherwise grab the data from tonight.

I can put in a set date and time manually :

i.e. ... where RDATE between ('08-FEB-03 18:00:00','DD-MM-YY hh24:mi:ss') and ('08-FEB-03 22:00:00','DD-MM-YY hh24:mi:ss')

But obviously it means the select statement is static. How can I check the current time and then pass this to the where clause so it requests the appropriate days data?

Any help, pointers, suggestions appreciated.

Thanks,

Don Received on Sat Feb 08 2003 - 09:47:52 CST