-
How do I change the Default Date Format to yyyy-mm-dd (NLS_DATE_FORMAT?).
-
See the alter session command at session level and NLS_DATE_FORMAT init paramter t database level
Reddy,Sam
-
CHANGING DEFAULT DATE FORMAT
IT CAN ALL BE DONE BY CHANGING REGISTRY EDITOR
IF USING WINDOWS CLIENT
/HKEY__LOCAL_MACHINE/SOFTWARE/ORACLE
ADD STRING VALUE
NLS_DATE_FORMATE DD-MM-YYYY
THANKS
PITAMBER SONI
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|