Introduction
It is very important to set custom date time format for date column in Oracle as By default, Oracle SQL developer displays date values as 08-NOV-16. If a user wants to see the time part (hour/minute/second) by default then s/he has to do some configuration within a Oracle SQL Developer.
Steps to Enable Date Format
User can follow below instruction to set custom Date Time format in SQL Developer, Please follow –
- Navigate to Oracle SQL Developer and go to Tools > Preferences.
- From the Preferences dialog, select Database > NLS from the left panel.
- From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.
- Once above steps are completed, Click on OK to apply changes and close the dialog.
- Execute the SQL Query to see the new Date Time Format in Date Column.
