Note
This variable was introduced in OceanBase Database V1.4.
Description
time_zone specifies the session time zone of the current tenant. The value can be an offset, such as '+08:00', or a geographical location, such as Asia/Shanghai.
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | +8:00 |
| Value range | [-12:59, +13:00] |
| Effective scope | |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
| Plan generation affected | Yes |
Examples
Set the variable at the session level
obclient> SET time_zone='+08:00';Set the variable at the global level
obclient> SET GLOBAL time_zone='+08:00';