SQL Developer

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!

SQL Developer NLS Setting not working

Orcl ApexOct 7 2019 — edited Oct 7 2019

Hi,

SQL Developer Version - Version 19.2.0.206 Build 206.2117.

I have setup NLS settings setup as below but when I am running query, tables with date columns are not showing HH:MM:SS AM/PM portion.

Can you suggested what is messed up here, I already tried restore window to factory setting and its not working. Its working when I issue ALTER statement in worksheet.

This post has been answered by Glen Conway on Oct 7 2019

Jump to Answer

Added on Oct 7 2019

#sql-developer

1 comment

970 views