How to read NLS_DATE_FORMAT?

Question

How do I read the current value of NLS_DATE_FORMAT in the oracle db?

Answer 1

In current sesion (client) settings:

select *
from nls_session_parameters
where parameter = 'NLS_DATE_FORMAT';

and in global database parameters:

select *
from nls_database_parameters
where parameter = 'NLS_DATE_FORMAT';

Demo: http://sqlfiddle.com/#!4/9eecb7/3282