set timezone globally (as a system parameter?)

[lmatz]

Right now, we can set it per session: https://docs.risingwave.com/docs/current/view-configure-runtime-parameters/#how-to-view-runtime-parameters

It is reasonable to fix it for all the sessions as typically the user only cares about the time zone they are living in or dealing with.

Making it one of the system parameters should work. But I suppose it would require a system restart to take effect?
Not sure if there is a better way to do so.

[yuhao-su]

alter system set timezone to xxx? Start a new session should work

[lmatz]

you are right

I am actually a bit confused

https://docs.risingwave.com/docs/current/view-configure-system-parameters/#:~:text=You%20can%20configure%20mutable%20parameters,CLI%20of%20the%20meta%20node.:

The page seems to imply that only variables mentioned above can be altered by alter system set statement.

But timezone is not in the list

[yuhao-su]

#16062

[lmatz]

Thanks, let me file a doc issue to make it more clear.

User and I both get lost on this...