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
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:
Post Comments (Atom)
No comments:
Post a Comment