如何修改Oracle SQL Developer SQL历史记录的时间戳显示格式？

Hey there! Let's get that SQL History timestamp looking readable instead of that long numeric string. First, that number (1525278069600) is a millisecond-precision Unix timestamp—it translates to roughly 05/02/2018 11:53:09, matching your desired format.

Since you're on the older 4.0.3.16 version, here are two approaches to fix this:

Option 1: Check Built-in Preferences (Quickest if Available) #

Some older versions still have a UI setting for this, let's check first:

• Open SQL Developer and go to Tools → Preferences
• Expand the Database category and select SQL History
• Look for a field labeled Timestamp Format (it might be near the bottom of the panel)
• Enter your desired format string, like MM/dd/yyyy HH:mm:ss
• Click Apply then OK, and refresh the SQL History panel to see the change

Option 2: Manually Edit the Configuration File (If UI Setting Doesn't Exist) #

If the above option isn't available in your version, you'll need to tweak the config file directly:

1. Close SQL Developer completely—changes won't take effect if it's running.
2. Locate the system configuration directory for your version:
   • Windows: C:\Users\<YourUsername>\AppData\Roaming\SQL Developer\system4.0.3.16.84\o.sqldeveloper\
   • macOS: ~/Library/Application Support/SQL Developer/system4.0.3.16.84/o.sqldeveloper/
   • Linux: ~/.sqldeveloper/system4.0.3.16.84/o.sqldeveloper/
3. Open the ide.properties file in a text editor.
4. Look for a line starting with sqldev.sqlhistory.timestamp.format. If it doesn't exist, add this line:

   sqldev.sqlhistory.timestamp.format=MM/dd/yyyy HH:mm:ss
   

5. Save the file and restart SQL Developer. Your SQL History timestamps should now display in the friendly format you want!

Format String Notes #

• Use MM for 2-digit months, dd for 2-digit days, yyyy for 4-digit years
• HH is 24-hour time; use hh for 12-hour time, plus a to add AM/PM (e.g., MM/dd/yyyy hh:mm:ss a)

内容的提问来源于stack exchange，提问作者telamonides