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!
Hello, Is there a way to change the display of DATE fields in the results data grid? Ours is displaying DD-MM-YYYY and we want it to display YYYY-MM-DD HH:MM:SS. Thanks.
Hi, Before you issue the query (in the same session) issue ALTER SESSION SET nls_date_format='your_date_format_here' Database Reference (0 Bytes) SQL Language Reference (0 Bytes) At some point we plan a way to automatically execute commands like this with each session that is established, but for now you will need to do it yourself or use a login trigger.
We do a lot of date/time analysis using Oracle Developer and I must admit, having to specify functions to show a timestamp for a column stored as date and time is annoying. In Oracle SQL Developer application, I am able to set the date/time formats in the NLZ preferences, could this be implemented for VSCode also? or at least return results in the database intended format.
Up !
In version 21.5 we added support for a login SQL script which you can use to change the NLS Date Format...