sql - How to read NLS_DATE_FORMAT? -


how read current value of nls_date_format in oracle db?

in current sesion (client) settings:

select * nls_session_parameters parameter = 'nls_date_format'; 

and in global database parameters:

select * nls_database_parameters parameter = 'nls_date_format'; 

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


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -