About
The parameter NLS_DATE_FORMAT control the format of the date datatype.
You can see here to see the different format possible.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
Oracle Database - NLS_DATE_FORMAT
The parameter NLS_DATE_FORMAT control the format of the date datatype.
You can see here to see the different format possible.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';