Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dates

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.


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US