Home » RDBMS Server » Server Administration » Win2k date setting for oracle 8i
Win2k date setting for oracle 8i [message #61388] Tue, 20 April 2004 19:41 Go to next message
kiran napit
Messages: 2
Registered: April 2004
Junior Member
my database oracle initially was in Win NT 4.0 with regional settings for date as dd-mon-yy. But now when i shifted to win2k the regional settings does not remain the same even though i changed it to dd-mon-yy, hence my applications does not take the date format for the database, what is the correct procedure to set the date format in win2k for dd-mon-yy, i do not need to change all date events in my application
thanks
kiran

Report message to a moderator

Re: Win2k date setting for oracle 8i [message #61391 is a reply to message #61388] Tue, 20 April 2004 21:25 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
try to change a value of key HKEY_LOCAL_MACHINESOFTWAREORACLEHOME0NLS_DATE_FORMAT to your format of date.

Report message to a moderator

Re: Win2k date setting for oracle 8i [message #61402 is a reply to message #61388] Wed, 21 April 2004 20:38 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You can change the NLS_LANG value in the registry or set it up in the user shell:

c:/> set nls_lang=american_america.utf8

for example.

Hope that helps,

Trifon Anguelov

DBAclick.com | DBA Forums

Report message to a moderator

Previous Topic: can i get oracle 8i on solaris 8 intel version free downloable?
Next Topic: Setting semsys in HP-UNIX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 08 13:43:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.