search

dbeaver / cloudbeaver

Cloud Database Manager
https://dbeaver.com/
Apache License 2.0
3.39k stars 370 forks source link

set timezone in helm chart for cloudbeaver #2709

Open Tartampion opened 3 months ago

Tartampion commented 3 months ago

Hi, How can set the cloudbeaver timezone in helm chart ? I tried several things like env TZ, time_zone, JAVA_OPTS "-Duser.timezone=America/New_York" ... @@session.time_zone is still UTC

Any idea on how to set the timezone in cloudbeaver helm chart ?

Thx

EvgeniaBzzz commented 3 months ago

Hi @Tartampion Where exactly do you look to see the time zone?

Tartampion commented 3 months ago

Hi, The db is configured in UTC and must remain that way for applications that access it. For example, in cloudbeaver the creation_date column is displayed in UTC and we want it to be in CEST. It could be a problem when we're modifying date manually in the db. We did it in phpmyadmin but we can't find how to do it in cloudbeaver. Cloudbeaver is deployed with helm chart on several namespaces, this configuration must be in a template or values.yaml.

Thanks for your help

EvgeniaBzzz commented 3 months ago

For now time can be shown in UTC only. And you can't set timezone with variable. We will add timezone selector to UI preferences. Thank you for bringing this to our attention!

jmc-o commented 2 days ago

Hi, This feature is really important for us, and i think for many users. To clarify the request : we need the session timezone to be set automatically set on every connection, based on a configured timezone value, such that all dates appear in the usable timezone and not UTC (which is a mess).

Currently the only way to get around this is to run a SQL command each time we connect : SET time_zone = 'Europe/Paris'; Note that the session timezone is not the same as the global timezone. One can check it with: SELECT @@session.time_zone;

Thanks to inform us when this feature is planned to be implemented.