The date shown is just dd/mm/yyyy with no hours:minutes:seconds
The solution can be found here on Zenx's blog, but to save me looking here it is also.
1. From SQL Developer, open menu Tools >> Preferences.
2. From the Preferences dialog, select Database >> NLS Parameters from the left panel.
3. From the list of NLS parameters, enter
4. Save and close the dialog, done!
2. From the Preferences dialog, select Database >> NLS Parameters from the left panel.
3. From the list of NLS parameters, enter
DD-MON-RR HH24:MI:SS into the Date Format field.4. Save and close the dialog, done!
Thanks Zenx.
Also, if you want milli-seconds add ':SSSSS' at the end.
4 comments:
For whatever the reason, this does not appear to work in my copy of SQL Developer 3. I have to change the NLS_DATE_FORMAT setting myself every time I log in:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY HH24:MI:SS'
Hmmm, not sure why that would be. I am on only 2.1.1.64
Excellent, thanks!
I put the 2 suggestions together and they worked - meaning, under Tools/Preferences/Database/NLS for Date Format, I entered DD/MM/YYYY HH24:MI:SS and that seemed to save and work correctly so you don't have to set it each new session.
Post a Comment