This content has been marked as final. Show 3 replies
you can set NLS_DATE_FORMAT to be anything you specify;regardless of NLS_LANGUAGE
Your settings are dependent on NLS_LANG on the client.
They are derived from (assuming Windows) the regional settings of the O/S.
This means in Western Europe the default 'American_America.WE8MSWIN1252'.
This makes the default NLS_DATE_FORMAT dd-mm-yy.
You can override this in the registry, or set up an after logon trigger.
Senior Oracle DBA
The default NLS_LANG setting for Oracle XE on Windows depends on your Windows regional settings.
For example with Windows French settings you get NLS_LANG with French settings:
SQL> @[.%NLS_LANG%] SP2-0310: impossible d'ouvrir le fichier "[.FRENCH_FRANCE.WE8MSWIN1252]" SQL>