Determining NLS_DATE_FORMAT Oracle

Oracle > NLS_DATE_FORMAT

NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and TO_DATE functions

Example:
Get NLS_DATE_FORMAT 

SELECT value
FROM   nls_session_parameters
WHERE  parameter = 'NLS_DATE_FORMAT'

Result: