Every time I install SQL Developer in a new computer I go to
Tools-> Preferences-> Database-> NLS and fix all date formats show they will display time as well:
- Date Format: DD/MM/RRRR HH24:MI:SS
- Timestamp Format: DD/MM/RRRR HH24:MI:SSXFF
- Timestamp TZ Format: DD/MM/RRRR HH24:MI:SSXFF TZR
However, there's a specific computer where this fails to have any effect: all DATE columns are displayed as *20-APR-11*. I need to open a SQL Worksheet and run this:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/RRRR HH24:MI:SS';
Given that this alternative works, I've saved it into a *.sql file and configured such file as startup script at
Tools-> Preferences-> Database-> Filename for connection startup script. However, I suspect I misinterpreted the feature since the script does not appear to run when I open a connection.
Any idea of why date format is getting ignored in this computer? I'm running latest stable version on Windows Server 2003 R2 against a remote 10g server.
P.S. You can't log in into this forum using Opera, can you?