What is best way for time comparison.

I have a table with 2 columns:

met_val_begin
met_val_end

I want to store a time of day value, for example, 8:00 and 18:00.

Then I want to write some sql that basically says

select * from table where current_time is between met_val_begin and met_val_end;

at the moment I'm doing it like this:

...where sysdate between
TO_DATE(TRUNC(SYSDATE) || ' ' || met_val_begin, 'DD-MON-RR HH24:MI') and
TO_DATE(TRUNC(SYSDATE) || ' ' || met_val_end, 'DD-MON-RR HH24:MI')

but that looks a bit hacked to me, any suggestions?

-Ethan
http://www.freetechnicaltraining.com
http://www.gnumetrics.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CDT