如何更改 DBeaver 时区/如何阻止 DBeaver 转换日期和时间 [英] How to change DBeaver timezone / How to stop DBeaver from converting date and time

问题描述

当我将 DBeaver 与 Cassandra 一起使用时，即使数据以日期或时间格式存储，没有任何时区，它也会显示 +01:00 的偏移量.这会导致一些奇怪的查询，如下所示:

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

那么，如何删除转换或将时区设置为 UTC?

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

推荐答案

我找到了另一个解决方案:

I found another solution:

在DBeaver根目录设置dbeaver.ini文件.

Setting dbeaver.ini file in DBeaver root directory.

打开文件:

-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

这篇关于如何更改 DBeaver 时区/如何阻止 DBeaver 转换日期和时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！