alter system nls_date_format 11g code example
Example: change nls_date_format
-- Date format for session
ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';
-- Date format for session
ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';