SQL*PLUS Date Output Format Change

Symptom:

   Sqlplus date output normally is like '11-MAY-11'  which does not have much detailed information we would like to see.

Solution:

  To change sqlplus date output, use sql:

alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH24:mi:ss';