| Date Problem??? [message #371061] |
Sun, 20 August 2000 10:59  |
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 #371067 is a reply to message #371063] |
Mon, 21 August 2000 11:59  |
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 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
