Date format in results data grid

User_V9SVZ

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.

Christian.Shay -Oracle

Hi,

Before you issue the query (in the same session) issue ALTER SESSION SET nls_date_format='your_date_format_here'

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/NLS_DATE_FORMAT.html#GUID-FC23EEEE-AA9F-4B3C-8CBB-888C9C0CA27F

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Format-Models.html#GUID-EAB212CF-C525-4ED8-9D3F-C76D08EEBC7A

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.

User_17VJ8

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.

User_JUFBQ

Up !

Christian.Shay -Oracle

In version 21.5 we added support for a login SQL script which you can use to change the NLS Date Format...