Re: query regarding system time

"June Moore" <jungewum_at_yahoo.com.au> wrote in news:1126307997.428908.235720_at_o13g2000cwo.googlegroups.com:

> Hi,
> Is there any way I can check if the system time is between a certain
> range (e.g. 3 - 9 pm)?
> e.g. select * from <table> where systime >= "15:00" and systime <=
> "21:00";
>
> thanks..
> JM
>
>

select sysdate
from dual
where to_char(sysdate,'HH24') between '15' and '21'; Received on Fri Sep 09 2005 - 20:54:59 CDT