Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is best way for time comparison.
Maybe:
where to_date(to_char(sysdate, 'HH24:MI'), 'HH24:MI') between
TO_DATE(met_val_begin, 'HH24:MI') and
TO_DATE(met_val_end, 'HH24:MI')
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Fri Jun 30 2000 - 00:00:00 CDT