Timestamps Not in Expected Timezone in dbForge Studio for Oracle
If you're encountering timestamps that don't match your system's timezone in dbForge Studio for Oracle, this can typically be resolved with a quick configuration update. This issue may arise due to default formatting settings or discrepancies in how time data is displayed when working with Oracle developer tools.
✅ Steps to Fix Timestamp Formatting
1. From the main menu, select Tools → Options...
2. Navigate to Data Editor → Formatting
3. Choose Timestamp in the Data type drop-down menu
4. Replace hh with HH in the Edit format field
This modification ensures that timestamps follow a 24-hour format and are correctly aligned with your system’s local time settings.
Additional Notes
Timestamp discrepancies may be influenced by the Oracle environment setup or version. For example, users who recently set up Oracle Database 23ai using the Oracle installer may experience timezone behavior variations due to default locale or session settings applied during installation.
Ensuring your IDE is synchronized with the database’s time configuration is especially important when managing workflows with modern Oracle distributions like Oracle Database 23ai.
If the issue persists after applying the recommended changes, please contact our support team. Include screenshots of your OS timezone settings, database session time zone, and application preferences to help us diagnose and resolve the issue faster.