How to change DBeaver timezone / How to stop DBeaver from converting date and time

Question

When I use DBeaver with Cassandra, it shows an offset of +01:00 even though the data is stored in Date or Times formats, that don't have any timezones. This results in some weird queries like this:

SELECT "Time"
FROM keyspace."Table"
ORDER BY "Time" DESC;

Time
00:00:00
23:00:00
22:00:00
...
01:00:00

So, how do I remove the conversions or do I set the timezone to UTC?

score 50 · Answer 1 · answered Jun 07 '22 at 15:12

50

v22.1.0 added this preference in the UI (no more modifying .ini files).

In Window -> Preferences. Go to User Interface and change the Client Timezone. Restart dbeaver.

Github PR here: https://github.com/dbeaver/dbeaver/pull/16467

answered Jun 07 '22 at 15:12

Gabe

5,113
11
55
88

2

Simple and works, pls upvote! – Gringo Suave Jul 13 '22 at 00:31
3

Best option. This should be accepted answer now. – deoomen Aug 12 '22 at 06:37

score 45 · Accepted Answer · answered Sep 30 '18 at 07:27

45

I found another solution:

Setting dbeaver.ini file in DBeaver root directory.

Open the file:

-startup
plugins/org.eclipse.equinox.launcher_1.4.0.v20161219-1356.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.551.v20171108-1834
-showsplash
# START: change jre version, not using the one in %JAVA_HOME%
-vm 
D:\ArPortable\Java\jdk1.8.0_171\jre\bin\server\jvm.dll
# END
# JVM settings
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
--add-modules=ALL-SYSTEM
-Xms64m
-Xmx1024m
# time zone
-Duser.timezone=UTC
# language
-Duser.language=en

answered Sep 30 '18 at 07:27

Archon

1,385
1
15
30

This doesn't work if the server timezone isn't UTC, or if you use multiple servers with different timezones. [See this answer](https://stackoverflow.com/a/54401047/8213783) – Evan Jun 17 '19 at 21:21
This fixed the "ERROR: invalid value for parameter "TimeZone": "Europe/Berlin"" for me with using CockroachDB on Windows 10. – Ferdy Pruis Jan 29 '20 at 09:33
See my answer below - there is a much easier option in settings UI starting in v22.1. https://stackoverflow.com/a/72533665/220997 – Gabe Aug 12 '22 at 14:09

score 23 · Answer 3 · answered Jul 26 '17 at 09:57

23

DBeaver uses the time in the computer that is installed, so changing the clock and restarting DBeaver works. But there is a way to do it only for DBeaver instead.

Close DBeaver.
Go to the DBeaver shortcut. Probably it is here:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\DBeaver
Right-click on it, choose Properties and in the Target box add -vmargs -Duser.timezone=UTC to the end, resulting in something like this:

"C:\Program Files\DBeaver\dbeaver.exe" -vmargs -Duser.timezone=UTC
Start DBeaver and the times now appear in UTC.

answered Jul 26 '17 at 09:57

Edu

2,354
5
32
36

3

Providing those parameters to the program didn't work for me, but I was able to just modify **dbeaver.ini** and add the `vmarg` there. Then it worked. – Shibumi Apr 13 '18 at 15:22
5

I had to add `-Duser.timezone=UTC` on the line just below `-vmargs` in __dbeaver.ini__, and restart the app. Putting it on the same line did not work. And this was inside the app package on MacOS, so it's bound to be overwritten during the next app update. – John Lemberger Jun 28 '18 at 18:44
@JohnLemberger That putting a configuration option on the same line as `-vmargs` doesn't work is expected: since DBeaver is Eclipse-based, [Eclipse.ini](https://wiki.eclipse.org/Eclipse.ini) settings and rules apply. – watery Jan 23 '19 at 16:21
can you give an example for setting Europe/Berlin timezone in dbeaver.ini? I tried -vmargs -Duser.timezone=Europe/Berlin – Leevi L Apr 08 '20 at 10:41
1

@LeeviL I would not advise using anything other than UTC for the reasons stated in the question. But for your case, if Europe/Berlin does not work, try CET, or +01:00 or related. – Edu Apr 08 '20 at 21:26
It's kind of crazy that there's no way to tell DBeaver to use the server's time zone in a way that persists across updates. – Alex Totheroh Jun 04 '20 at 20:05

score 14 · Answer 4 · answered Mar 19 '20 at 14:55

On Mac

Go to Finder > Applications
Right click on DBeaver and select Show Package Contents
Open Contents\Eclipse\dbeaver.ini
After the -vmargs line, add this: -Duser.timezone=UTC
Save file and restart DBeaver

Limitation: You’ll have to redo this for every version upgrade.

Windows

Go to DBeaver install directory C:\Program Files\DBeaver
Open dbeaver.ini
After the -vmargs line, add this: -Duser.timezone=UTC
Save file and restart DBeaver

Source: This blog

valentinmk · Answer 5 · 2021-04-05T12:10:43.590

13

UPDATE 2021-04-05: Based on recent comments I need to clear that this solution suitable only for Clickhouse DB. Additionally it is very old answer, please, take in mind that it is currently 99% outdated solution.

I think it was fixed in some previous release.

Just go to Settings -> Editors -> Data Formats and select 'Use native date/time format' checkbox.

enter image description here

edited Apr 05 '21 at 12:10

answered Jan 28 '19 at 11:30

valentinmk

597
7
18

4

This doesn't work for me, dates and times are still converted to local time – Wes Feb 13 '19 at 16:00
@Wes I have double checked solution and it works for me. But this works for a DBeaver 5.3.2 and Clickhouse database for a fields with DateTime type – valentinmk Feb 15 '19 at 14:11
If it helps, I am working in Postgres and running `to_timestamp()` on an epoch timestamp. The solutions above worked for me though. – Wes Feb 17 '19 at 16:04
11

No, this does **_not work_**. It only affects the **_format_** of timestamps (i.e., "YYYY-MM-DD" vs. "MM-DD-YYYY", etc.), not the **_value_** displayed (i.e., UTC vs. your local time zone). – Mr. Lance E Sloan Mar 26 '20 at 14:32

Breno Medeiros de Oliveira · Answer 6 · 2019-11-07T19:44:40.020

7

If you wanna see the TimeZone of your Selects, you can go to DBeaver Preferences:

Preferences

Click on Type, and change it to Timestamp
In Pattern Value add the termination " Z z" and see the Sample result like this: 2019-11-06 07:38:54 -0300 BRT
Tap Apply, and Apply and Close
Done :)

edited Nov 07 '19 at 19:44

answered Nov 06 '19 at 10:46

Breno Medeiros de Oliveira

608
6
11

score 6 · Answer 7 · answered Apr 19 '21 at 21:55

For DBeaver in Linux

Quit DBeaver if it's running.

Edit /usr/share/dbeaver/dbeaver.ini, adding -Duser.timezone=UTC to -vmargs section. E.g.:

 -vmargs
 -XX:+IgnoreUnrecognizedVMOptions
 --add-modules=ALL-SYSTEM
 -Dosgi.requiredJavaVersion=11
 -Xms64m
 -Xmx1024m
 -Duser.timezone=UTC

Open DBeaver and view timestamps in UTC.

Viewing full timestamp values

Window > Preferences
Editors > Data Editor > Data Formats
Check 'Disable date/time formatting'

Before: 2021-04-19 16:14:23

After: 2021-04-19 16:14:23.056178+00

Tested with PostgreSQL.

Aashutosh Taikar · Answer 8 · 2019-04-08T17:20:30.173

4

If this is the JDBC driver issue with regards to the timezone:
Right click on the connection to open connection settings

change the timezone

OR you may also change the server timezone driver property

edited Apr 08 '19 at 17:20

answered Apr 08 '19 at 17:10

Aashutosh Taikar

135
1
9

Alex Fedotov · Answer 9 · 2022-05-08T21:11:15.210

4

As of today (DBeaver 21.3.2 CE) you need to go to Window > Preferences. In the dialog pop-up window choose: Editors > Data Editor > Formats, then choose Timestamp in the dropdown in the Format frame and click on Timesone line.

Right-click there and print UTC

Click the 'Apply and Close' button in the lower right corner. Done!

edited May 08 '22 at 21:11

answered Feb 04 '22 at 15:55

Alex Fedotov

497
3
8

How to change DBeaver timezone / How to stop DBeaver from converting date and time

9 Answers9

For DBeaver in Linux

Viewing full timestamp values

Linked