We have a lot of date columns containing date+time values, which I often need to see while browsing table data.
Default NLS settings for date format are dd.mm.yyyy for 'Russia', so our DB uses this by default, which is in turn used by SQLDeveloper. So, to see the time values, I should either write select with appropriate to_char manually, or change NLS settings under "Database" in the preferences. Of course, changing NLS setting seems preferable.
However, changing NLS date format has certain side effects. For example, it affects various tasks, mainly involving exporting, which are launched from SQLDeveloper, because default to_char format for date values also changes. Of course we could blame lazy developers for not specifying formats explicitly, but it doesn't change the fact that the results of task execution are "wrong", and that can be rather hard to notice until subsequent tasks fail. Also, if I'm not mistaken, NLS_DATE_FORMAT also affects to_date default format, making import from text and querying date columns rather annoying. It's better to be safe than sorry, so I have to keep NLS settings
So, is that possible to set date format only for displaying the values in data grid, without affecting NLS settings in any way? I'm fine with pretty much anything, including writing an extension myself if necessary, I just need it to work. If it's impossible, could SQL Developer team please add such setting, or at least show a tooltip on mouseover, displaying 'full' cell value?