# 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:

```sh
-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.

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