Goto Tools -> Preference and Look for Database tree and expand it and select NLS.
For e.g. DD-MM-RR HH24:MI:SS will give me a result as 31-MAY-11 14:01:12
Showing posts with label sql developer. Show all posts
Showing posts with label sql developer. Show all posts
Thursday, June 02, 2011
Custom Date Format for Oracle SQL Developer
By default the SQL Developer only display the data in Date-Month-Year format. If you would like to change the output it is fairly easy.
Goto Tools -> Preference and Look for Database tree and expand it and select NLS.
For e.g. DD-MM-RR HH24:MI:SS will give me a result as 31-MAY-11 14:01:12
Goto Tools -> Preference and Look for Database tree and expand it and select NLS.
For e.g. DD-MM-RR HH24:MI:SS will give me a result as 31-MAY-11 14:01:12
Subscribe to:
Posts (Atom)