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
.
TEXT
NLS_DATE_FORMAT = option-value
See Oracle Database Reference for more information about NLS parameters, including valid values.