Re: What is best way for time comparison.

Ethan Post wrote:
>
> 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.

You could always use the number of seconds since midnight....and define the column as a number.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse