Forum Stats

  • 3,733,073 Users
  • 2,246,690 Discussions


NLS Masks WIth Extension

User_6BTKC Member Posts: 18 Green Ribbon

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?


Sign In or Register to comment.