Did you check the registry on the machine that you execute sqlplus on to see
if there is nls_date_format there?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:38 AM
Hi,
The default date format for an
I checked my Registry..
Nls_date_format is not set in the registry..
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: how to change nls date format.
Did you check
Yes. You can do that when you are creating an instance, define the parameter
nls_date_format in the init.ora file as per your requirement, then the
nls_date_format for the Instance would be as supplied by you.
Alter Session/Alter System would do the same at the time so defined.
Vikas Khanna
Do you have nls_language parameter specified in your init.ora file?
I think, Oracle will not pick up the value for nls_date_format from
init.ora unless you have nls_language specified in it.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list
Hi,
The default date format for an instance is dd-mon-.
Ex when issue the following statement Select to_char(sysdate) from dual;
The output is 01-Jan-2002.
I want to change this format to mm/dd/.
According to Oracle documentation this can be changed @ sesion level by the
following :