Wednesday, May 25, 2011

Change format of Date displayed in SQL Developer

To change the format of Date column displayed in SQL Developer worksheets (output of SQL queries) do the following:
  1. Select Tools > Preferences
  2. Expand the Database section
  3. 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

No comments:

LinkWithin

Related Posts Plugin for WordPress, Blogger...