Skip to content

PL/SQL Developer NLS_DATE_FORMAT

How do I Change NLS Date Format in PL/SQL Developer ?

Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS level. It depends on what you want to do.

GUI tools like PL/SQL developer usually override NLS_DATE_FORMAT at any level once you connected to the database in it.

To permanently set NLS_DATE_FORMAT in PL/SQL developer to improve your productivity, we need to change it in the "Preferences" of the tool.

Preferences

Here we navigate the function menu to "Preferences".

PL/SQL Developer - Tools - Preferences
PL/SQL Developer - Tools - Preferences

NLS Options

We go for "User Interface" -> "NLS Options" and enter "Date" and "Time" format in the 2 fields.

PL/SQL Developer - Preferences - Change Date and Time Format
PL/SQL Developer - Preferences - Change Date and Time Format

Please note that, the set of date time elements in "Date" and "Time" does NOT follow Oracle's, but follows Windows standard date and time format strings.

Test

After you close the windows, the new datetime format takes effect immediately, so you don't have to logout / login.

Let's check the result.

PL/SQL Developer - New NLS_DATE_FORMAT
PL/SQL Developer - New NLS_DATE_FORMAT

We have customized NLS_DATE_FORMAT in PL/SQL developer permanently.

Leave a Reply

Your email address will not be published. Required fields are marked *