134 

   135 Adjust date format.

   136 ===================

   137 ::

   138 

   139   column parameter format a32;

   140   column value format a32;

   141   select parameter, value from v$nls_parameters;

   142 

   143   alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd HH:MI:SS';

   144   alter session set NLS_TIMESTAMP_FORMAT = 'MI:SS.FF6';

   145   alter session set NLS_TIME_FORMAT = 'HH24:MI:SS.FF6';

   146 

   147   select sysdate from dual;

   148