Tuesday, October 25, 2011

Timestamp problem with SQL Developer

SQL developer doesn't display timestamp for any query result.

Simple Fix:
In Oracle SQLDeveloper Go to: Tools >> Preferences >> Database > NLS Parameters and update your Date Format field to DD-MON-RR HH:MI:SS value