The NLS_DATE_FORMAT option specifies the default format for datetime values.
Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSION SET option = value.
See Oracle Database Globalization Support Guide for more information about NLS parameters, including valid values.