Purpose
DBTIMEZONE returns the time zone of the current database instance. In OceanBase Database, the database time zone is fixed to +00:00 and cannot be modified.
Syntax
DBTIMEZONE
Return type
The return type is VARCHAR2.
Examples
The following example returns the time zone of the current database instance.
obclient> SELECT DBTIMEZONE FROM DUAL;
+------------+
| DBTIMEZONE |
+------------+
| +00:00 |
+------------+
1 row in set