Originally posted by eeswar
Still if you want this to appear in client m/c's as well, then you have to edit the registry settings to change the NLS_DATE_FORMAT in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. This will always take priority over the server settings.
This only applies on the local machine, right? Not for the entire server....in which case alter session can do. I needed to change on the database level, not on the local machine or session.