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?