Table of Contents

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';