Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> query regarding system time
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