... or more concise, just use a date literal: "DATE '2004-06-25'" Kind regards, Lex. --------------------------------------------- visit my website at http://www.naturaljoin.nl --------------------------------------------- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jacques Kilchoer Sent: Friday, June 25, 2004 19:45 To: oracle-l@xxxxxxxxxxxxx Subject: RE: Dates 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. -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf ---------------------------------------------------------------- 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 -----------------------------------------------------------------