Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dates
... or more concise, just use a date literal: "DATE '2004-06-25'"
Kind regards,
Lex.
-----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.