The time displayed by Oracle SQL Developer includes the time, minute, and second settings. oracledeveloper

The time displayed by Oracle SQL Developer includes the time, minute, and second settings. oracledeveloper

Oracle SQL Developer is a free integrated development environment developed by Oracle. Oracle SQL Developer is a free, non-open-source graphical tool for developing database applications. You can use SQL Developer to browse database objects, run SQL statements and scripts, edit and debug PL/SQL statements. You can also create, execute, and save reports. This tool can connect to any Oracle database of Oracle 9.2.0.1 or later, and supports Windows, Linux, and Mac OS X systems.

So how do I set the time displayed by Oracle SQL Developer to include time, minute, and second?

Refer to settings 1:

Change tool -- preferences -- database -- NLS -- date format from DD-MON-RR to DD-MON-RR HH24: MI: SS

Refer to Settings 2:

Change the value of Tools --> Preferences --> Database --> NLS Parameters --> Date Format from "RR-MM-DD"

"YYYY-MM-DD HH24: MI: SS", so that the displayed time contains minutes and seconds.

Refer to settings 3:

Choose Tools --> Preferences --> Database --> NLS --> Date Format,

Change the default format: DD-MON-RR to the format you want, for example, to 'yyyy-MM-DD HH24: MI: ss', then you can enter the hour and minute.

It is convenient to copy data with excel.

With the above three settings, you can easily solve the problem that the time displayed by Oracle SQL Developer includes time, minutes, And seconds. This article is simple and easy to understand. If you have any shortcomings, I hope you can give us your valuable comments. Thank you.