Oracle Database - NLS_DATE_FORMAT
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';
Articles Related
- Oracle Database - Globalization (Localization, NLS parameter)
- SQL Plus - Formatting Reports
- Oracle - Date Datatype
- OBIEE - Cast as date - Which date format to use ?
- Oracle Database - Territory (NLS_TERRITORY)
- OBIEE - Date Format in presentation variable, dashboard prompt and logical SQL
- Toad - The date format with null and decode
- Oracle Database - Datatype Datetime
Recommended Pages


