**********************************************************************************
* Description: SQL for Altering Session Nation Language Support [NLS] Date Format
* Compatiablity: RDBMS 11g, 12c
* Date: 11:23 AM EST, 01/03/2017
**********************************************************************************


SQL> alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';

	     Session altered.

	
SQL> select startup_time from v$instance;

	STARTUP_TIME
	--------------------
	02-JAN-2017 18:20:55

	
	

Your Comments