Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> query regarding system time

query regarding system time

From: June Moore <jungewum_at_yahoo.com.au>
Date: 9 Sep 2005 17:02:10 -0700
Message-ID: <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 Received on Fri Sep 09 2005 - 19:02:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US