Hi Jmodic!

I had tried both ways i.e.,by setting new key in the registry in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLE_HOME
and also by setting in the new string as:

variable name:NLS_DATE_FORMAT
VALUED-MON-YYYY

On the other hand,I had also set it permanently in the INIT.ORA Parameter File.But still I am not getting the date format in 2001!

What else should I do!

Could you please explain me step by step the setting of both registry and INIT.ORA Files for NLS_DATE_FORMAT.

Regards,

Amitstora.