Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] ORACLE date select problem?
Free yourself from the NLS_DATE_FORMAT by being specific. Try:
where datestamp < to_date('31-DEC-1996','DD-MON-YYYY');
(note the 4 digit year)
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> L <leed_at_chele.cais.net> 10/13/00 12:06PM >>> I tried this, still same.
On Fri, 13 Oct 2000, Gillies, Garry wrote:
> Hi L,
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20 >=20
>=20
>=20 >=20
>=20> All internet traffic to this site is=20
> ++++++++++++++++++++++++++++++++++++
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: L
INET: leed_at_chele.cais.net=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 13 2000 - 13:15:05 CDT
![]() |
![]() |