Re: Oracle Y2K Question

From: <f.van.bortel_at_vnl.nl>
Date: Thu, 25 Mar 1999 11:02:30 +0100
Message-ID: <36FA09B6.D9A0DA3A@vnl.nl>

Mike Fellows wrote:

> My question being when I run a SQL command to look for all records
> greater than 31-DEC-99 any valid hit is returned correctly, if however
> I try to look for data BETWEEN say 19-DEC-99 and 20-FEB-02 i dont get
> the expected response.The same applies if i look for all records less
> than eg 20-FEB-00 so in essence when carrying out queries only when I
> look for records greater than a given date do I get the correct
> answers.

If you haven't changed anything in your SQL environment, you use the default 'DD-MON-YY' format - change it! ALTER SESSION SET NLS_DATE_FORMAT 'DD-MON-YYYY'; BTW not sure SQL supports the RR format - seem to recall that was Forms only Received on Thu Mar 25 1999 - 04:02:30 CST