To change the format of Date column displayed in SQL Developer worksheets (output of SQL queries) do the following:
- Select Tools > Preferences
- Expand the Database section
- In the NLS Date format field, enter the desired date format as supported by Oracle
My preferred format is DD-MON-RR HH24:MI:SS