Y2K problem in NT4.0.

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Mon, 25 May 1998 15:15:34 +0800
Message-ID: <6kb5ha$oeq$1@imsp009a.netvigator.com>

Hi,

In our company, we use oracle 7.3.4 ent. for WinNT 4.0 server. We want to change NLS_DATE_FORMAT to 'DD-MON-RR'. I have add the entry

NLS_DATE_FORMAT="DD-MON-YY" and add values NLS_DATe_FORMAT=DD-MON-RR in the register of NT server. Howerver, if we issue

'select to_char(to_date('1-may-98', 'dd-mon-yy'), 'dd-mon-yyyy') from dual;' we get '01-may-2098' not '01-may-1998'. The sysdate of the database is '25-may-2010'. Do I miss to do something? Please help! Furthermore, I have update my version from 7.3.2 to 7.3.4 however, the NLS_RDBMS_VERSION in table NLS_DATABASE_PARAMETER only shows 7.3.2.2.0 not 7.3.4 although I set the compatible to 7.3.4 in the init file, do I need to set any parameter? Please help!

TIA. Best Regards,
Man Yeung Received on Mon May 25 1998 - 02:15:34 CDT