Hi!akhil!Reg:NLS_DATE_FORMAT!
hi!
I was able to set the NLS_DATE_FORMAT ON NT successfully to-day thus which successfully returns date format in 2001 whenever we type 001.
Do it this way:
1.Open your WINNT Server My Computer Property settings and go to Environment Settings.There type NLS_DATE_FORMAT and in the value type DD-MON-YYYY.
2.Next, on your Client NT machines,do the same environment settings .
3.After that Log in to sql*plus,and then type:
select sysdate from dual;
Hope this helps!
Let me know after you've finished up with this config successfully!
BTW:any idea how to set up NLS_DATE_FORMAT DD-MON-YYYY on WIN98 platforms!
Regards,
Amitstora.