********************************************************************************** * 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