Home » SQL & PL/SQL » SQL & PL/SQL » Date format DD-MON-YYYY
Date format DD-MON-YYYY [message #2991] Wed, 28 August 2002 09:50 Go to next message
Pavel
Messages: 6
Registered: October 2001
Junior Member
Can't change the format of the date in SQL Plus from DD-MON-YY to DD-MON-YYYY.
In init.ora and in registry NLS_DATE_FORMAT is already set to 'DD-MON-YYYY'
If I do "ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY' it works for Sql Plus,
but still problems with other apps.
As always it's on users PC, mine is fine.
Any suggestions?
Thanks.

Report message to a moderator

Re: Date format DD-MON-YYYY [message #2993 is a reply to message #2991] Wed, 28 August 2002 10:45 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://osi.oracle.com/~tkyte/Misc/NLSDateFormat.html

Report message to a moderator

Previous Topic: Problems in running SQL*Plus
Next Topic: Re: want to stop the insert/delete/update transaction in an AFTER TRIGGER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 10:45:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.