Home » RDBMS Server » Server Administration » Date Problem???
Date Problem??? [message #371061] Sun, 20 August 2000 10:59 Go to next message
rikky
Messages: 2
Registered: August 2000
Junior Member
The default date format is DD-MON-YY,
I want the format to be mm/dd/yyyy hh24:mi:ss.
i want it to be permanent.
I 've tried using the NLS_Session_parametrs & NLs_database_parameters. it doesn't work.
even if i change it in login.sql,
alter session set nls_date_format ='mm/dd/yyyy hh24:mi:ss', it works for 1 session only, whenevr i disconnect & then connect again, it shows the default date format.
Please Help????

Thanx
Vishal
Re: Date Problem??? [message #371063 is a reply to message #371061] Mon, 21 August 2000 05:45 Go to previous messageGo to next message
Rajesh Matkar
Messages: 20
Registered: September 1999
Junior Member
Hi,
You must set this parameters permanently in initSID.ora parameter file for permanent save.

All the best .

Rajesh
Re: Date Problem??? [message #371067 is a reply to message #371063] Mon, 21 August 2000 11:59 Go to previous messageGo to next message
SureshJ
Messages: 4
Registered: August 2000
Junior Member
This is a very trivial solution really.
Alternatively, you could also include the 'ALTER SESSION' statement in the glogin.sql or login.sql file in the client M/Cs to overcome your hitch.

Regards.
Suresh :-)
Re: Date Problem??? [message #371074 is a reply to message #371067] Wed, 23 August 2000 06:33 Go to previous messageGo to next message
SureshJ
Messages: 4
Registered: August 2000
Junior Member
Hi Mahaveer,
That was a nice solution but unfortunately, it doesn't work . I made the entry and rebooted the M/C, but it still doesn't work. For Ex. When I execute a Qry, I still get the entry in default Oracle Format, instead of the format specified in the reg. Entry!!!
Any other suggestions???

Regards.
SureshJ
Re: Date Problem??? [message #371076 is a reply to message #371067] Wed, 23 August 2000 20:15 Go to previous message
mahaveer
Messages: 16
Registered: July 2000
Junior Member
Hi Suresh,

Please you include the NLS_DATE_FORMAT directly in the HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE. The same thing is working for me. If you are using orace8i, you include under HOME0.

Mahaveer
Previous Topic: PL/SQL output directable to an HTML frame target?
Next Topic: Re: Sending E-Mail from Oracle 8.0.6.0.0
Goto Forum:
  


Current Time: Fri Mar 29 04:08:13 CDT 2024