Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news4.google.com!news.glorb.com!gail.ripco.com!cox.net!news-xfer.cox.net!p02!fed1read03.POSTED!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: query regarding system time
From: "IANAL_VISTA" <IANAL_Vista@hotmail.com>
References: <1126307997.428908.235720@o13g2000cwo.googlegroups.com>
Organization: Black Hole, Inc.
Message-ID: <Xns96CCC06F6F455SunnySD@68.6.19.6>
User-Agent: Xnews/5.04.25
Lines: 17
Date: Sat, 10 Sep 2005 01:54:59 GMT
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read03 1126317299 68.7.204.31 (Fri, 09 Sep 2005 21:54:59 EDT)
NNTP-Posting-Date: Fri, 09 Sep 2005 21:54:59 EDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251221

"June Moore" <jungewum@yahoo.com.au> wrote in 
news:1126307997.428908.235720@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';