How to set the time that the Oracle SQL developer displays in minutes and seconds _oracle

Oracle SQL Developer is a free integrated development environment produced by Oracle Company. Oracle SQL Developer is a free, open-source, graphical tool for developing database applications, using SQL Developer to browse database objects, run SQL statements and scripts, edit and debug pl/sql statements. You can also create execution and save reports. The tool can connect to any Oracle 9.2.0.1 or above Oracle database, supporting Windows, Linux, and Mac OS X systems.

So how do you set the time that the Oracle SQL developer display to include minutes and seconds?

Reference setting 1:

Modify the tool-preferences-database--nls--date format from DD-MON-RR to DD-MON-RR HH24:MI:SS

Reference setting 2:

Change the value of the tools--> Preferences--> Database--> NLS Parameters--> Date format from "Rr-mm-dd" to

"Yyyy-mm-dd HH24:MI:SS", so that the time of display is included minutes and seconds.

Reference Setting 3:

Select Tools--> Preferences--> Database--> nls-->date Format,

The default format: DD-MON-RR to the format you want, such as ' Yyyy-mm-dd HH24:MI:SS ', so you can enter minutes and seconds.

It's convenient to copy with Excel.

Through the above 3 kinds of settings to easily resolve the Oracle SQL developer display time minutes, this article is simple and easy to understand, very good, there are deficiencies are also hope that the heroes put forward valuable comments, thank you.