Set dbeaver timezone to UTC (default timezone)

set-dbeaver-timezone-to-UTC.md

For Linux Users

1. Go to directory: /usr/share/dbeaver
2. Edit dbeaver.ini file
3. In that file add -Duser.timezone=UTC this line under -vmargs tag
4. Save it and restart dbeaver.
5. Enjoy with correct date without any date conversion.

Finally your dbeaver.ini file will look like this:

-startup
plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.551.v20171108-1834
-showsplash
--launcher.GTK_version
2
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
--add-modules=ALL-SYSTEM
-Xms64m
-Xmx1024m
-Duser.timezone=UTC

For Windows Users

Follow this link:

https://stackoverflow.com/questions/45323552/how-to-change-dbeaver-timezone-how-to-stop-dbeaver-from-converting-date-and-ti

---

Run below commands and see the difference.

SELECT now();
SELECT now() AT time ZONE 'Asia/Kolkata'

Latest version has an option in the UI. Please upvote the answer if you find it helpful
https://stackoverflow.com/a/72533665/220997

Latest version has an option in the UI.
https://stackoverflow.com/a/72533665/220997

Life-saving.

https://www.sameerahmad.net/blog/dbeaver-timezone

Thanks!

thanks!