Permanently changing default date format DD-MON-YY to YYYY-MM-DD H:Mi:S
485125Jan 24 2006 — edited Jan 24 2006I want to change the default format of date. I wrote NLS_DATE_FORMAT="YYYY-MM-DD" in initXE.ora. when i write show Parameter on SQL Plus in SQL Plus at Server it is showing me that NLS_DATE_FORMAT is YYYY-MM-DD but when i issue "select sysdate from dummy", it is showing me the default "DD-MON-YY" format. I don't want to use Alter Session and i don't want to use To_char to change it. Is there anyway i can i change it in initXE.ora and it will change it globally. I can't change the code because we don't have the source of the code. We just have Database settings file in which we can change the connection specific settings.
Please help me in this situtation.