RE: Dates

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Sat, 26 Jun 2004 09:28:47 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNIECBCFAA.lex.de.haan@naturaljoin.nl>

... 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jacques Kilchoer Sent: Friday, June 25, 2004 19:45
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sat Jun 26 2004 - 02:27:19 CDT