To change the NLS_DATE_FORMAT setting Use the below command, it will help to solve your problems for after restart database. Also, if you do not want to do this at the instance level, you can make session NLS_DATE_FORMAT based on sql queries. ALTER SESSION SET NLS_DATE_FORMAT=’DD-MM-YYYY’; [oraetkb@sp000dba01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 […]