Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS Masks WIth Extension

User_6BTKCMar 10 2021

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?

This post has been answered by Christian.Shay -Oracle on Mar 10 2021
Jump to Answer

Comments

Processing

Post Details

Added on Mar 10 2021
10 comments
127 views