oracle time sysdate NLS_DATE_FORMAT code example

Example: oracle nls_date_format

-- Date format for session
ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';