I would add that an expression like "to_date ('25-JUN-04')" depends on your session's current NLS_DATE_FORMAT settings and language settings. The explicit conversion is always the best and you should avoid the use of language-dependent terms like month names (unless of course the date is being formatted for display) to_date ('2004/06/25', 'YYYY/MM/DD') -----Original Message----- Dan Tow a still better, functionally equivalent condition would be NC_DATE_CLS >= TO_DATE('25-JUN-04') AND NC_DATE_CLS < TO_DATE('26-JUN-04') if you want to limit an index range scan using the NC_DATE_CLS column. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------