This can't be right - can't display time part of a DATE field.
PaulieSep 1 2011 — edited Sep 2 2011Hi all,
I have a table with one DATE field. It wasn't displaying times with the date,
so I searched and found a post telling how to change my NLS settings
in the Preferences.
I did this and it didn't change, so I thought, OK, I'll shut it down and restart.
Still no. So, I shut it down again, deleted all the records form my table, reinserted
them and then restarted SQLDeveloper.
Despite the fact that it has retained the change in NLS settings, it STILL*
doesn't display the time.
There is no problem in SQL*Plus. Quite frankly, this is poor.
Paul...