Forum Stats

  • 3,874,342 Users
  • 2,266,727 Discussions


NLS Masks WIth Extension

Hi All,

Maybe I am just missing something in how the extension works. Here's the situation. In one of the databases I work with (11c in this case) the default NLS Date Format is DD-MON-YY. In the extension if i right click that database and open a new scrap SQL file and do a simple query like:

SELECT some_date_field FROM some_table;

The output comes back in MM/DD/YYYY HH:MI:SS

If I alter session alter session set nls_date_format='YYYY-MM-DD:HH:MI:SS';  or really anything and re-execute the query the results stay in this same format. Is there no way to utilize NLS_DATE_FORMAT in the extension? Maybe some setting I am missing?

Best Answer