Re: Oracle Y2K Question

Hi Mike,

This may be a dumb question, but did you set the nls_date_format to dd-mon-rr.
The default in sqlplus is dd-mon-yy, and you seem to have changed forms apps only. You either need to edit your registry on your client pc or issue an
alter session set nls_date_format='DD-MON-RR' before you carry out these tests.
Otherwise the 02 will be interpreted as 1902, while the 99 is interpreted as 1999.

Hth,

Sybrand Bakker, Oracle DBA

Mike Fellows wrote:

> Hello there I am running Oracle V7.2.3 (Forms 3 and Menu 5) on a HP
> UX 10.01 platform. I have carried out the fixes for Y2K compliancy as
> recommended by Oracle via the use of ON_VALIDATE triggers to set any
> YY year datatype to RR and this seems OK. 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. Any help would be much
> appreciated Cheers Mike

Received on Wed Mar 24 1999 - 15:57:56 CST