Home » RDBMS Server » Server Administration » setting nls_date_format in SQL PLUS
setting nls_date_format in SQL PLUS [message #370710] Fri, 21 January 2000 11:35 Go to next message
Rajeev
Messages: 34
Registered: January 2000
Member
Currently I am using the following command to set the nls_date_format in SQL PLUS:
alter session set nls_date_format = 'DD-MON-RR';

Can anyone tell me if I can set it permanently once so that I don't have to reset it everytime I login to SQL PLUS?

Any help will be greatly appreciated.

Thanks
Rajeev

Report message to a moderator

Re: setting nls_date_format in SQL PLUS [message #371371 is a reply to message #370710] Tue, 10 October 2000 00:14 Go to previous message
Sandeep P Dandekar
Messages: 3
Registered: October 2000
Junior Member
You can set date format in init.ora file

Report message to a moderator

Previous Topic: Re: Dynamic SQL Value Error Urgent
Next Topic: Date function - add time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 15:11:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.